Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Func. generates insert and select for large table

By jobejuan,

Generates an insert statement including column list.  Useful for identity table data copying.  Just modify the code generated to select and insert the needed fields.  Saves time on large table inserts (also generates a select statement.  Use part or all of the SQL generated.  Saves development time when dealing with large tables.

Total article views: 165 | Views in the last 30 days: 1
Related Articles

Generate Insert Scripts

Generate an insert of your data


Generate Insert script

Generate Insert script


Auto generate insert Procedure

Auto generate insert Procedure


Generate Insert Statements

This script Generates the insert statements for a particular table.


Generating Insert Statements

This article from new author Oleg Netchaev describes the cursor-less script used to generate insert ...

sqlinsider scripts