I want to see the insert script used along with the data that is used in the creation of that table.Can you please

write any query or procedure for to...

I don't want that insert generate script.I want to see which insert query is used in inserting data into the table.

select * into table2 from table1

This query will automatically create table2 in your database.You can modify the above query as

per your need.Many times i had use this query in...