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

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

backup job is failing

By ramyours2003

I have configured always on  and  log backup is failing with the error Command:...

Limiting the Data Frame

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Limiting the Data Frame

Micro Credentials

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Micro Credentials

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers