Select Records Into XML Structure

Posted: March 10, 2009 in SQL Server 2005 - XML

To select records from a table into XML format, open a new query window and execute the following line of code:

-- Get a records from table into XML format
SELECT  *
FROM    
FOR XML AUTO, ROOT;
<code></code>
-- The above select will return rows in the following structure
-- <root>
--     <TableName ColumnName="ColumnValue" />
-- </root>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s