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 |
|
sasproc
Starting Member
1 Post |
 Posted - 2009-08-12 : 00:56:21
|
| Hi all,I am using SQLSERVER2000,i want to write a query and then re-direct it to an output file like .txt or xls format.so please can you guide mehow to do this as i am very new.Please help me.Thanks & Regards,SASPROCsasproc |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-08-12 : 01:04:28
|
you can use BCP queryout to a text fileSee http://msdn.microsoft.com/en-us/library/aa174646%28SQL.80%29.aspx
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-08-12 : 02:18:00
|
ugh, prefer bcp to that!
elsasoft.org |
|
|
|
|
|
|
Direct results from a query to an output text file