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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-12-11 : 09:15:17
|
| Raimund writes "I am a newcomer to SQL. We are using SQL 7.0 for storing and analyzing internet access cata. We have a couple of stored procedures on the server, which are activated via a MS Access Client. The rusults (selcts on the tables) are displayed on the client PC. Because of some jobs are running a long time, I would like to run them at night on the SQL-Server (via SQL-Agents scheduler) and the results should be stored in text files.In SQL-Server Agent you can EXECUTE a sp, but channeling the result to a file (>outputfile, like in UNIX) does not work to the EXECUTE-Statement (syntax error). How can I export the results of queries to a file or import parameters for sp's from a file? Must I use tmp-tables for storing the rusults of a query? Why does a simple "redirect" like in UNIX not work?Thanks for hints." |
|
|
S.Krishnan
Starting Member
6 Posts |
Posted - 2002-12-12 : 09:12:08
|
| Would recommend you use Bulkcopy with Query option wherein result of a query can be taken to the text file. |
 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-12 : 10:24:48
|
| http://www.sqlteam.com/item.asp?ItemID=4722 |
|
|
|
|
|
|
Transact-SQL and exporting to text files, reading parms from files