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
 Old Forums
 CLOSED - General SQL Server
 Generating XML file in SQL Server 2000

Author  Topic 

dotnet2k5
Starting Member

2 Posts

Posted - 2006-09-19 : 02:13:48
Hi guys/gals,
I m a newbie to SQL server 2000. Is there any way of creating an XML file in a stored procedure in sql server 2000. If yes, Please tell me how to do it.

Thanks

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-09-19 : 02:19:48
Yep - SELECT * FROM table FOR XML

Check out books online for more info because it can do lots of stuff.
Go to Top of Page

dotnet2k5
Starting Member

2 Posts

Posted - 2006-09-19 : 02:31:03
Thanks Timmy for ur reply...

I got the query already. But how do i write it to a file..
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-19 : 05:08:29
Maybe this topic will help you?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72165


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -