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 .