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
 Site Related Forums
 Article Discussion
 Article: OSQL: Storing result of a Stored Procedure in a file

Author  Topic 

AskSQLTeam
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]http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]
Go to Top of Page
   

- Advertisement -