Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: OSQL: Storing result of a Stored Procedure in a file

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2000-09-19 : 11:01:26
Amit writes "What is the exact syntax for storing output of a Stored Procedure or a query in a text file. I was trying bcp utility, but is giving error. Thanks in anticipation"

Article Link.

Jeff Moden
Aged Yak Warrior

652 Posts

Posted - 2009-02-18 : 18:07:18
They probably didn't have it in SQL Server 7, but BCP has a "QUERYOUT" feature in 2k and above.

--Jeff Moden
"Your lack of planning DOES constitute an emergency on my part... SO PLAN BETTER! "
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row"

For better, quicker answers, click on the following... [url][/url]
Go to Top of Page

- Advertisement -