R Glen Cooper

How To Avoid MERGE in SQL Server

Introduction This article shows how to script a basic merge between two tables, without using MERGE. This can be handy when you're merging a pair of tables with hundreds of columns, since the script doesn't know anything about them. This technique introduces and populates some auditing columns (IS_DELETED, IS_INSERTED, IS_UPDATED, TRANSACTION_DATE) for each record, and runs fast. […]

4 (3)

2020-04-14

8,550 reads

Blogs

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Daily Coping 13 Aug 2020

By

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

SQL Homework – August 2020 – More DML Triggers

By

Well, I’m running a bit late. Both for this month and the fact I...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

trouble with exec @sql

By polkadot

I want to search all databases having sprocs containing text 'text I am looking...

BDC Orchestration

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BDC Orchestration

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers