hai
FOR XML is generally used to return the results of a query (rows and columns) in XML format. If your database contains HTML data in, say, a TEXT column, you don't need to use FOR XML. Simply execute a query and get the HTML data back in the result, then display the HTML on the page.
If you provide more information about the structure of your database, how you're accessing it (ADO, ADO.NET, etc.) and which Web framework/programming language you're using, we can provide a more specific example
Last edited by bagitha; 10-26-2009 at 02:57 AM
|