Technical Article

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

170 reads

Blogs

SQL Homework – October 2022 – Replication part 2

By

In August we started taking a look at replication. We learned some of the...

Function Vs. Performance

By

Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...

Daily Coping 3 Oct 2022

By

Today’s coping tip is to write down three things you appreciate about yourself. I...

Read the latest Blogs

Forums

Version Controlling Lambdas

By barakgodi

I know there are lambda versions. But I want to know if this can...

subscriber part of ALWAYSON

By SQL Galaxy

Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover.  It seems...

SQL Server Licensing Question

By atangvels

I'm in the process of replacing a sql server 2012 with 2019. How do...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers