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

169 reads

Blogs

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Gathering More Digital Data with Tile Slim

By

After my wallet misadventures, I ordered a Tile Slim to track my wallet. It...

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Read the latest Blogs

Forums

subreport blank lines

By ibax

blank line in subreport

Enabling indexes

By SQLHeap

If I disable an index for a large insert/update/delete, what happens when it's enabled...

Database Triggers

By mballentine

Hi, I need to send out an email every time an alarm level is...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers