Keywords: SQL Server, table data, build INSERT statement
Feedback please contact: [Email protected]
Brief introduction
Database data generates an INSERT (MSSQL version), which generates an INSERT or update SQL script for the data in the table. For example, you maintain two databases, and the additional data in one database is expected to be executed in another data.
: Http://www.vidarsoft.cn/download/SQLInsert.zip
csdn:http://download.csdn.net/detail/swordmanli/9631889
Operating Environment
1. Executable program SQLInsert.exe
2, need. NET framework4.0, if there is no environment, please download the installation first
To set up a data source for a specific operation
After the download is complete, unzip.
To set up a data source:
After the point is determined, all tables in the database are extracted.
Generate INSERT statement
The generated SQL is selected to be copied to the target database for execution.
MS SQL Server table data generation INSERT statement