Friday, February 22, 2013

Make Insert Queries for the Existing Data in MS SQL


Step 1 : Right Click the MS SQL Data Base. Go --> Tasks --> Generate Scripts 


Step 2 : Click the Next button.

Step 3 : Select the table/s data which you want to take as insert query. Then Click Next

Step 4 : Click the advance button and select the Types of data to Scripts option and set it to the Schema and data. Then give a path for save your query. 


Step 5 : Wait till the process compete and collect you query . 

No comments:

Post a Comment