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 - 2007-03-12 : 09:28:18
|
| Robert writes "Is there a way to export a complete table to a text file using only tsql commands without depending on BCP or DTS? I was wondering if INSERT INTO would have possibilities." |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-16 : 12:12:07
|
| What are you going to connect to sql with? Have to have a front end to run the code from. You can use OSQL or Query Analyzer. Both will let you save the results.Raymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-16 : 12:13:36
|
| Or OPENROWSET.Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
SQL command to Export table to flat file