SQL Merge Statement Tutorial | Merge Statement in SQL

Hello All,

Welcome to the Atharv Guruji channel.
Please like the video and subscribe to the channel.

SQL Queries: -
CREATE TABLE EMP
(
EMPID INT IDENTITY,
EMPNAME NVARCHAR(50),
AGE INT
)

INSERT INTO EMP(EMPNAME,AGE)
VALUES('ATHARV',20)

INSERT INTO EMP(EMPNAME,AGE)
VALUES('ADITI',20)

INSERT INTO EMP(EMPNAME,AGE)
VALUES('ANURAG',20)
SET IDENTITY_INSERT EMP ON
INSERT INTO EMP(EMPID,EMPNAME,AGE)
VALUES(6,'ANURAG',20)
SET IDENTITY_INSERT EMP OFF

CREATE TABLE SourceEMP
(
EMPLOYEEID INT IDENTITY,
EMPLOYEENAME NVARCHAR(50),
AGE INT
)

INSERT INTO SourceEMP(EMPLOYEENAME,AGE)
VALUES('ATHARV BAROLIYA',21)

INSERT INTO SourceEMP(EMPLOYEENAME,AGE)
VALUES('ADITI BAROLIYA',22)

INSERT INTO SourceEMP(EMPLOYEENAME,AGE)
VALUES('ANURAG BAROLIYA',23)

INSERT INTO SourceEMP(EMPLOYEENAME,AGE)
VALUES('ANKUR BAROLIYA',24)

SELECT * from EMP
SELECT * from SourceEMP

MERGE EMP AS Target
USING SourceEMP AS Source
ON (Target.EmpID=Source.EMPLOYEEID)
WHEN MATCHED
THEN
UPDATE
SET
Target.EMPNAME=Source.EMPLOYEENAME,
Target.AGE=Source.AGE
WHEN NOT MATCHED BY TARGET
THEN
INSERT (EMPNAME,AGE)
VALUES(Source.EMPLOYEENAME,Source.AGE)
WHEN NOT MATCHED BY SOURCE
THEN
DELETE
OUTPUT INSERTED.*;

Keywords:
SQL Merge Statement Tutorial
Merge Statement in SQL
Merge Statement in SQL Server

First Power BI Report for Beginners

Rolling Calendar in Power BI

2nd highest salary using Offset

Primary Key

Print star pattern in sql

#sql
#sqlinterviewquestionsandanswers
#sqlserver
#merge

[JoakimNyström-xb]

It is really difficult to debug MERGE, so I would NOT recommend using it just because of that issue alone. An UPSERT statement will do exactly the same AND will be much easier to debug.