MS SQL Server table data generation INSERT statement

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