How to catch an xml column from the Sqlserver Table.

Question

Hi all,

    In my current project, i want to get an xml column from the sqlserver2008 table and store that value in a string variable in asp.net.

    How can i catch the xml column from the table. can anyone help me in writing the query to get the xmlcolumn from the table.
Thanks,
K.S.R. Prasad.

Answer 1

What do you mean by XML column? Does this column store XML data in it?