Exporting partial table records as INSERT script
Here is one way to do what you want (taken from this Stack Overflow answer by KT.:


  
  Do a select [whatever you need]INTO temp.table_namefrom [... etc ...].
  
  
  Right-click on the database in the Object Explorer => Tasks => Generate Scripts
  Select temp.table_name in the "Choose Objects" screen, click Next.
  In the "Specify how scripts should be saved" screen:
  Click Advanced, find the "Types of data to Script" property, select "Data only", close the advanced properties.
  Select "Save to new query window" (unless you have thousands of records).
  Click Next, wait for the job to complete, observe the resulting INSERT statements appear in a new query window.
  Use Find &amp; Replace to change all [temp.table_name] to [your_table_name].
  drop table [temp.table_name].
  
  


NOTE:  The above sample uses the schema name temp. You may have to create that schema name for the script to work for you.