>Hi,
>
>I need to write a stored procedure that will select a row from a table, then populate/create an XML string and return this XML string. (This stored procedure will be called from an ASP.NET application and the returned XML is parsed by C# code). My question (since I have not done it before), how do you create an XML in a stored procedure? And when you set values into this XML how to "point" to a value in the column? TIA and any suggestions or snippet of sample code.
Hi Dmitry
Have you tried the FOR XML clause in SQL?
SELECT * FROM tablename FOR XML AUTO
see...
http://blah.winsmarts.com/2007-2-bak2basics__learn_t-sql_-_for_xml.aspxKurt