Script to generate insert staments
I'm not an expert in MS SQL Server...
I am trying to write an SQL script to create an insert statement for each row of table TEST which has fied A (int) and field B varchar(30), in my MS SQL database. I would like to save those insert staments in a txt file to be able to apply that data back to another database.

Any idea about how to do it?

Thanks,

Abner.

 
Script to generate insert staments
===

I'm not an expert in MS SQL Server...
I am trying to write an SQL script to create an insert statement for each row of table TEST which has fied A (int) and field B varchar(30), in my MS SQL database. I would like to save those insert staments in a txt file to be able to apply that data back to another database.

Any idea about how to do it?

Thanks,

Abner.

 