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

168 reads

Blogs

Daily Coping 20 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

The Diverse Data Platform–Dativerse.io

By

The other day I got a note from Ben Weissman the other day that...

Extended Events and Azure SQL Database

By

Knowledge of how your system behaves is vital to better control, maintain, and grow...

Read the latest Blogs

Forums

usage of BCP and BULK INSERT

By 892717952

as I'm not clear how to use bcp and bulk insert in the following...

sequence of SQL server execution plan

By 892717952

As per my understanding,  when we read the execution plan, the sql server is...

An Empty Integer Numpy Array

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Empty Integer Numpy Array

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers