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 |
|
harahmani
Starting Member
5 Posts |
 Posted - 2007-07-05 : 15:27:09
|
| Hii m new in sqlserver databases i need to know how to "store output of data from stored procedure in a text file "suppose i have a stored procedure which has to cuculate some out put from some tables and in the end i want that all out put in comma delimited text file. my databse name is check1 i need help please thanks in advance take carebye |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-05 : 16:28:40
|
| Use xp_cmdshell to call bcp in your sp, you can find details in books online. |
 |
|
|
|
|
|
storing out put of data from stored procedure in a