创建在SQL Server 2016中生成insert语句的查询

1.  Connect to your TEST server on SQL Server management studio.
2.  Expand the Databases node.
3.  Right-click your Test Database > Tasks > Generate Scripts:
4.  The Introduction page opens. Select Next to open the Chose Objects page. You can select the entire database or specific objects in the database. Select  Script specific database objects (select tables table)
5.  Select Next to open the Set Scripting Options page. Here you can configure where to save the script and some additional advanced options.
a. Select Save to new query window.
b. Select Advanced and make sure these options are set:

    Types of data to script set to Data only.

步骤5.b

请改用SQL Server导入和导出向导: https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard?view=sql-server-2017