How to upload a content of a table into sql-file (the set of INSERTs)
using standard MSSQL utilities?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi

See Davids links if you want individual inserts although it would be alot
quicker if there are a reasonable number of rows to use bulk insert, bcp or
dts.

John

"Evgeny Gopengauz" <evgop@ucs.ru> wrote in message
news:41832184$0$10069$c397aba@news.newsgroups.ws.. .
> How to upload a content of a table into sql-file (the set of INSERTs)
> using standard MSSQL utilities?
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Evgeny,

Feel free to use our DTM SQL editor (www.sqledit.com) for that purpose. It
allows you to export results of the query exeution as a set of INSERT
statements. If you want to automate this process please try out our DTM
Migration Kit (www.sqledit.com/mk) and use Export to SQL rule.

EG> How to upload a content of a table into sql-file (the set of
EG> INSERTs) using standard MSSQL utilities?

Igor Shekalev, http://www.sqledit.com, SQL editor with ODBC support