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 - 2006-11-16 : 09:42:19
|
| venkatesh writes "Hi all,I have a simple sql Query, when I execute the query the result should also be written to a text file. Can I do that in SQL 2000?Thanks-Venky" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-16 : 09:42:57
|
| From where are you executing query?If it's QA, then you can set Tools, Options, Results, Results to File option and execute query to save output to file.Otherwise, you can use OSQL utility.Read about it more in BOL.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-16 : 11:40:24
|
http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspxGo with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
output file