>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.


See FOR XML clause of the SELECT statement