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 |
|
Ali.M.Habib
Yak Posting Veteran
54 Posts |
 Posted - 2009-07-07 : 16:21:48
|
| I want to write sql output of many queries to one file (that will be created by sql)I use bcp but it so slow and have problems , do uhave any suggestion I searched alot without result any advicebest regards |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 13:08:50
|
| you can use BULKINSERT or DTS export import task |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-09 : 00:11:21
|
| BCP is pretty fast. Seems you have an I/O issue...? Is same query slow in Query Analyzer? |
|
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2009-07-19 : 20:33:28
|
Heh... BCP is anything but slow unless there's a bad query driving it or you have a disk I/O problem. Either problem will hinder all other methods as well.As a sidebar, I'd just about give my eye-teeth to know how to export to a test file using BULK INSERT ;-)--Jeff Moden
"Your lack of planning DOES constitute an emergency on my part... SO PLAN BETTER! ""RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row" |
|
|
|
|
|
|
write to text file using sql