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-05-08 : 08:01:53
|
| Tim writes "How to use SQL 7.0 bcp's QUERYOUT feature to select data to a file, without using a Stored Procedure. The 'Select' syntax would be in a file, not in the BCP command line. Any ideas?" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-08 : 16:30:34
|
| Never used that syntax, but BOL states that the bcp must be based on a query. And a query can be turned in to a View, so why not create a view and bcp out the view?Brett8-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-08 : 17:26:49
|
| I have never used the QUERYOUT option either. I would suggest doing it how Brett mentioned though that way you don't have to type out the query each time (since you'll probably run it more than once), you'll just select on the view which has all the details.TaraEdited by - tduggan on 05/08/2003 17:27:10 |
|
|
|
|
|
|
bcp's queryout without using a SP