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 |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2005-05-10 : 04:49:37
|
| hi, I am running a query from QA. but instead of clicking on the icon for results to file is it possible to code it ?eg :SELECT * FROM TABLEOUTPUT TO C:\Table_Data.txtthank you for any info.Jamie |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-05-10 : 05:47:42
|
| exec xp_cmdshell 'bcp "select * from table" queryout "C:\table_data.txt" -c'MadhivananFailing to plan is Planning to fail |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2005-05-10 : 07:01:37
|
| thank you! |
|
|
|
|
|
|
output to a file