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: