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 - 2002-03-31 : 22:53:51
|
| Arshad writes "Hello,I have small doubt. I want to save resultset returned by stored procedure. I know one way by which I can save the resultset into file (for example .txt file), but I am not convinced with such kind of solution as it's lengthy process and I believe there must be some other best way to do this.Could you please let me know if there is any direct way of saving resultset return by Store Procedure into file.Thanks in advance.Cheers,Arshad" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-03-31 : 23:31:46
|
| bcp and osql will both do it.see www.nigelrivett.com for examples.or dts probably.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy.Edited by - nr on 03/31/2002 23:40:39 |
 |
|
|
|
|
|
Saving Resultset return by Stored Procedure To physical file