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.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 storing out put of data from stored procedure in a

Author  Topic 

harahmani
Starting Member

5 Posts

Posted - 2007-07-05 : 15:27:09
Hi
i 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 care
bye

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.
Go to Top of Page
   

- Advertisement -