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-03 : 09:47:55
|
| Bjorn writes "Hi!I want to export the data in a table (any table) to a T-SQL query batch file (*.sql) consisting of INSERT-statements only. I know that the MySQL database has a utility for that kind of export, but I don't seem to be able to find anything like it for the Microsoft SQL Server.Would be thankful for your help. - Bjorn" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-01-03 : 10:47:52
|
You need a query.select 'insert into mydb.owner.mytable(col) values(''' + col + ''')'from mydb.owner.mytable Then use this query as the source for you export.Jay White{0} |
 |
|
|
|
|
|
Export data from a table to a SQL query batch with INSERT-command