create xml file from sql script

Question

how to Generate xml file in sql server 2005 using tsql

sth · Accepted Answer · 2009-08-17 16:00:55Z

4

Select Emp_Id,Emp_Name from tblEmployee Where Emp_Id < 3
For XML AUTO,ELEMENTS
--For XML [MODE],ELEMENTS

MODE

AUTO, RAW, EXPLICIT

Result [AUTO]

<tblEmployee>
 <Emp_Id>1</Emp_Id>
 <Emp_Name>AAA</Emp_Name>
</tblEmployee>
<tblEmployee>
 <Emp_Id>2</Emp_Id>
 <Emp_Name>BBB</Emp_Name>
</tblEmployee>

Result [RAW]

Above Xml with Instead of <tblEmployee> here..... <ROW> and </tblEmployee> is </ROW>

edited Aug 17, 2009 at 16:00

sth

231k56 gold badges288 silver badges370 bronze badges

answered Aug 17, 2009 at 10:58

Dipoos

Sign up to request clarification or add additional context in comments.

Comments

Saharsh Shah · Accepted Answer · 2013-06-28 07:19:11Z

1

Stored proc exec DBName.dbo.Table is

select * from table for xml path 
SET @SQL= 'bcp "exec DBName.dbo.Table" queryout c:\myfile.xml -w -r -t -SServerName -T'
EXEC Master..xp_CmdShell @SQL

edited Jun 28, 2013 at 7:19

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

answered Apr 28, 2009 at 5:45

rmdussa

1,55710 gold badges28 silver badges52 bronze badges

Collectives™ on Stack Overflow

create xml file from sql script

2 Answers 2

MODE

Result [AUTO]

Result [RAW]

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

MODE

Result [AUTO]

Result [RAW]

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related