View Single Post
  #4 (permalink)  
Old June 5th, 2007, 04:14 PM
miamikk miamikk is offline
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to miamikk
Default

FOR XML AUTO generates an xml file but do you know or direct me to syntax on how to save the file to a folder ?


Quote:
quote:Originally posted by happygv
 KK,

Which version of SQL server are you using?

If it is Sql server 2000...
For XML output, you need to consider using
Code:
FOR XML AUTO
at the end of SELECT statement.

For HTML output, you may consider using sp_makewebtask and sp_runwebtask


_________________________
- Vijay G
Strive for Perfection
Reply With Quote