Question: how to extract data as insert statements from sql server?
Answer: If we wanted to create INSERT scripts from the data in the table, right-click on the database name and select Tasks > Generate Scripts... from the context menu.
The Generate and Publish Scripts window will open. ... 
The next screen allows you to output the data to a file, clipboard or new query window.