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: 2
 
Related Articles
SCRIPT

Generate Insert Scripts

Generate an insert of your data

FORUM

Generate Insert script

Generate Insert script

FORUM

Auto generate insert Procedure

Auto generate insert Procedure

SCRIPT

Generate Insert Statements

This script Generates the insert statements for a particular table.

ARTICLE

Generating Insert Statements

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

Tags
miscellaneous    
sqlinsider scripts    
t-sql    
 
Contribute