Generation of XML from sqlserver 2005 db

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 2005 Forums

Transact-SQL (2005)

Generation of XML from sqlserver 2005 db

Author

Topic

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2007-10-31 : 15:43:22

I want to create a xml file from sqlserver 2005 db.
Please help .

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-10-31 : 15:45:58

Um okay. Providing more details will help us help you. Reading SQL Server Books Online will help you as well.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-10-31 : 15:49:54

look into "for xml" in books online

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
SSMS Add-in that does a few things: www.ssmstoolspack.com

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2007-10-31 : 15:55:19

I want to generate the xml from a single which id is a primary key.


Example:
Table:Einfo

ID  Name  Type  Gd    dt
--  ----  ----  --    ---
1   sam   N     F    2007-08-16
2   Chr   N     M    2007-09-16
3   Rob   Y     M    2007-09-16

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources