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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-06 : 08:17:38
|
| Nides writes "Hi,I'm a newbie at SQLServer. I was wondering if it were possible to write the return values of a stored procedure to a text file. The PRINT command does not have the parameter to place where the file (or output) would be.If its not possible, what are my alternatives aside from inserting the output to a table and querying it back.I hope you could enlighten me.Thanks a bunch,Nides" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-06 : 13:33:03
|
| You could capture the return values in your sp and use the file system object to write them to the file. I think you could also just bcp it outMike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Writing retrun values to a file