how to read the xml data from sql server

[icanmakeiteasy]

hey can any one tell me how to read the xml data from sql server.... thanks in advance

icanmakeiteasy

[J4amieC]

1. Open a connection 2) Issue a SQL Command using one of the FOR XML commands or read froma n Xml column 3) Close Connection Further reading[^]

[icanmakeiteasy]

thanks for reply i have a xml file at c:\sample.xml i want to read the sample.xml file from my stored procedure how can i?

icanmakeiteasy

[Wendelius]

Based on your posts, use the OPENROWSET[^] function, like:

SELECT * FROM OPENROWSET(BULK 'c:\sample.xml', SINGLE_BLOB) AS somealias

The need to optimize rises from a bad design.My articles[^]