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 - 2003-01-30 : 08:21:27
|
| Alex writes "Hi: How can I Bcp records from table to a flat file. I want to Bcp only those records which meet my WHERE criteria which involves 2 tables. I don't want to create tmp table for this. Can I use select statement within Bcp?. If yes then what is the syntax for that? I tried to use the following syntax but it didn't work.bcp "SELECT * FROM pubs..authors" queryout authors.txt -U garth -P pw -cThanksAlex" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-30 : 08:51:40
|
| http://www.sqlteam.com/item.asp?ItemID=4722 |
 |
|
|
|
|
|
Question related with Bcp