View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 06:01 PM
BJ
 
Posts: n/a
Default how to use bcp command to output stored procedure result

Hello all

I can use bcp command to output database views to text file. My
statement is:
bcp database_name..viewname out output_filename.txt -Uusername
-Sservername -Ppassword -c

However, an error occurs when I use the same statment to output stored
procedure result. I typed:
bcp database_name..stored_procedure_name out output_filename.txt
-Uusername -Sservername -Ppassword -c

Could anyone give me some suggestions?

Thanks

BJ

Reply With Quote