SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: OSQL: Storing result of a Stored Procedure in a file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 09/19/2000 :  11:01:26  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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.

Starting Member

0 Posts

Posted - 10/24/2000 :  16:28:22  Show Profile  Reply with Quote

how can I write an array using asp

Go to Top of Page

Chief SQLTeam Crack Dealer

4144 Posts

Posted - 10/24/2000 :  17:15:02  Show Profile  Visit graz's Homepage  Reply with Quote

About the best you can do in SQL 7 is to use CSV's to impersonate Arrays. Your best bet is to use a temp table. They are as close as you can get and really fast.

Go to Top of Page

Jeff Moden
Aged Yak Warrior

651 Posts

Posted - 02/18/2009 :  18:07:18  Show Profile  Reply with Quote
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... http://www.sqlservercentral.com/articles/Best Practices/61537/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000