Advertisement

04.30.2007 at 10:43AM PDT, ID: 22543148
[x]
Attachment Details

SQL Server: How generate INSERT statements to populate table data (like mysqldump)?

Asked by ZuZuPetals in SQL Server 2005, MySQL, MS SQL DTS

Tags: insert, sql, server, statements, generate

In the MySQL world there is a very handy command line program called mysqldump that (in addition to making CREATE TABLE statements) as creates INSERT INTO TABLE statements for the data itself.

How do I generate the INSERT's like this in the SQL Server 2003 world?Start Free Trial
 
 
Loading Advertisement...
 
[+][-]04.30.2007 at 11:49AM PDT, ID: 19003615

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MySQL, MS SQL DTS
Tags: insert, sql, server, statements, generate
Sign Up Now!
Solution Provided By: ptjcb
Participating Experts: 2
Solution Grade: A
 
 
[+][-]05.01.2007 at 03:44AM PDT, ID: 19007059

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.01.2007 at 03:45AM PDT, ID: 19007062

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32