.Net at glance
Thursday, May 29, 2008
Xml in sql server 2005
declare @strXML XML;
SET @strXML ='
1
Suresh
2
Kunal Srhimali
'
--print @strXML
SELECT
custData.Customer.value('CustomerID[1]','int') ID,
custData.Customer.value('CustomerName[1]','nvarchar(50)') CustomerName
FROM @strXML.nodes('Customers/Customer') AS custData(Customer
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment