Func. generates insert and select for large table

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.

2003-02-21

166 reads

Blogs

The T-SQL Tuesday Corollary

By

T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics...

How to Import Perfmon Data into a SQL Server for Analysis

By

If you followed the last video, I showed you how to set up windows...

How To Set Up Perfmon for 24×7 Collection

By

I just released a new training video (one of many to be released in...

Read the latest Blogs

Forums

OLAPQueryLog does not work for SSAS Tabular mode

By Tho Le

I running into a problem when I try to setup querylog in SSAS. The...

MasOffer Affiliate m?t hình th?c ki?m ti?n v?i ti?p th? liên k?t

By ngocha97

[/b] MasOffer là m?ng ti?p th? k?t liên r?t l?ng danh ? Vi?t Nam....

Code to auto-update tables on set date

By thetubageek

I am in a project where information is being pulled from a database then...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers