How to create XML Data using T-SQL

home / software / tips and tricks / How to create XML Data using T-SQL

Updated: 10/15/2011 04:10 AM
Author: Shiju Mathews

Status: Resolved.

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

alt="Add your business to our listing Free"