Question: how to export data from sql server as insert statement?
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.