This blog will show you how to create an xml from sql query having sql data. Write down the followng query to generate xml:- WITH XMLNAMESPACES ('http://www.dossia ...

This class makes it very easy, almost trivial, to convert SQL query results into XML, but a major disadvantage of OracleXMLQuery is that it is a proprietary solution.

I have the following CTE's, and I'm trying to combine XML1 and XML2 CTE's in Sql Server by their common refid key. ;With TBL1_Fruits As (Select '1' as refid, 'Apples' as fruits, 'Red' as color, ...

Since XML is now a full-fledged datatype in SQL Server, you can easily create a new table that contains a field having XML in it, using the SQL Server Management Studio (formerly, Enterprise Manager).

To view the Showplan XML Statistics Profile event file in SQL Server Management Studio, on the File menu, point to Open, and select File. Browse to the directory where you saved the Showplan XML ...