In case you want to export all the rows in a table as insert statements, here's how to do it:
- Open MS SQL Server Management studio and login to your desired database server
- Right click database >> Tasks >> Generate Scripts
- Choose Objects: Select specific database objects >> Select the table you want to export
- Set scripting options: Select Save to file then click Advanced
- Proceed to next steps until table is successfully scripted, the click on Finish
And you're done, you've now exported table data as insert statements.