How to generate required xml format by sql query

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

How to generate required xml format by sql query

Author

Topic

Kishh143
Starting Member

2 Posts

Posted - 2012-08-28 : 10:46:49

Hi
I need to generate required xml format by sql query
Please help

Expected result

<code>
<timevalue value="20120101"/>
<value xsi:type="sa" value="10"/>
</code>

Kish

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-08-28 : 11:09:01

Assuming you have similarly named columns in a table:

;WITH XMLNAMESPACES('uri' AS xsi)
SELECT
	timevalue AS [timevalue/@value],
	'sa' AS [value/@xsi:type], 
	val AS [value/@value]
FROM YourTable
FOR XML PATH('code');

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources