Category: SQL Server
view more software Tips and Tricks
Updated: 10/15/2011 04:10 AM
Author: Shiju Mathews
It is easy to create xml data using T-SQL. Consider the following example.
Use the T-SQL Script to generate above XML:
To create xml from the table called "tblState", using columns names as element, use the following sql