SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Generating XML file in SQL Server 2000		  Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

dotnet2k5
Starting Member

2 Posts
Posted - 09/19/2006 :  02:13:48  Show Profile
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
Flowing Fount of Yak Knowledge

Australia
1242 Posts
Posted - 09/19/2006 :  02:19:48  Show Profile  Visit timmy's Homepage
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 - 09/19/2006 :  02:31:03  Show Profile
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

Sweden
29138 Posts
Posted - 09/19/2006 :  05:08:29  Show Profile  Visit SwePeso's Homepage
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
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000