Sql Server 2K5 - Save out Table data as INSERT INTO statements?

[NewsBot]

We're using MS Sql Server 2005.* Now im used to dealing with the excellent MySql.* With MySql i was able to save out a Sql query that represented my data within a table.* I want the same output from a couple of my Sql Server 2K5 tables.* Basically Im after the following output:

 

INSERT INTO MyTable (Field1, Field2) VALUES (data1, data2)

 

Where Field1/2 is an actual field name and data1/2 are actual data pulled from the dbase.* I can then take this sql output and run it on a different dbase to insert the data.

 

How do i save out the data in my sql server 2k5 table in this way?

 

Thanks.

 

 

More...

 

View All Our Microsft Related Feeds