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 |