Var Vs Dynamic

2012-08-21T08:15:00.001-07:00

The main difference between Var and Dynamic in .NET world is Var is static and Dynamic is runtime.

Var gets to set to the target type at the compile time and Dynamic gets set at the run time.

Querying XML Columns in SQL (CROSS APPLY)

2012-04-27T07:53:00.000-07:00

Here is an example on how to query data from XML column

Hope this is Self Explanatory

create table TestTable (ID int, Name varchar(100), Configuration xml)

insert into TestTable values (1001,
'Test 1',
'<Root ID="RootID1"><Child ID="childID1">child name 1</Child><Child ID="childID2">child name 2</Child></Root>')

select t.ID,
t.Name,
CChild.child.value('./@ID' , 'varchar(100)') ChildID,
CChild.child.value('.' , 'varchar(100)') ChildName,
CRoot.root.value('./@ID' , 'varchar(100)') RootID
from TestTable t
cross apply t.Configuration.nodes('Root/Child' ) as CChild(Child)
cross apply t.Configuration.nodes('Root') as CRoot(root)

select t.ID,
t.Name,
CRoot.root.value('./@ID' , 'varchar(100)') RootID,
CRoot.root.value('./Child[1]' , 'varchar(100)') ChildName,
CRoot.root.value('./Child[1]/@ID' , 'varchar(100)') ChildID
from TestTable t
cross apply t.Configuration.nodes('Root') as CRoot(root)

awesome comments

Prakash Technical blog

Var Vs Dynamic

Querying XML Columns in SQL (CROSS APPLY)