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 |
|
trebian
Starting Member
4 Posts |
 Posted - 2003-05-08 : 21:30:59
|
| Hello good folks:I simply need to write the results from a select statement to be written to a txt file. This has to be in a script, which the openview admin. will place in its scheduler (its back end is MS SQL server) to run. He will then ftp that file to me. How do I do that.For example:If I have SELECT A, B, C FROM TABLE123 ; I need the result to go to a txt file.Much thanks,TreThe more I learn, the more I realize how less I know! |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-05-08 : 21:41:59
|
| Look up BCP in Book on Line (The help file for SQl Server)DavidM"SQL-3 is an abomination.." |
 |
|
|
trebian
Starting Member
4 Posts |
Posted - 2003-05-08 : 22:07:29
|
| Hello David. I am embarassed to say that my forte is not SQL server nor I have any access to it either (the admin. being a prick is having me write this-I can do the SQL part ok just the write reult to txt file is the issue).Any how, is there any other way a link that I could get to this topic?Much obliged,TreThe more I learn, the more I realize how less I know! |
|
|
|
scullee
Posting Yak Master
103 Posts |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
trebian
Starting Member
4 Posts |
Posted - 2003-05-09 : 17:06:01
|
| Well good folks, thank you so very much for your help. I have written what I learned from the articles. Much thanks,TreThe more I learn, the more I realize how less I know! |
|
|
|
|
|
|
MS SQL write help