General discussion

Locked

Stored Procedure

By EricRB ·
I am trying to create a stored procedure that will use a query to extract data in an xml format and output it to a file.
I was hoping for something like this

Set @xml = (Select * from table1 where col1='test' FOR XML RAW)

then
echo to a filename using xp_cmdshell

but it will not work.
I know how to do this with vb but i need the code to be in the stored proc.

Can anyone assist me?

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums