SQL Merge Statement Tutorial | Merge Statement in SQL

Pubblicato il: 27 aprile 2025
sul canale di: Atharv Guruji

221

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
   • First Power BI Report for Beginners | Powe...

Rolling Calendar in Power BI
   • Rolling Calendar in Power BI | How to Crea...

2nd highest salary using Offset
   • 2nd highest salary using offset | 2nd high...

Primary Key
   • primary key | what is primary key | comple...

Print star pattern in sql
   • print star pattern in sql  #sql #sqlserver...

#sql
#sqlinterviewquestionsandanswers
#sqlserver
#merge

In questa pagina del sito puoi guardare il video online SQL Merge Statement Tutorial | Merge Statement in SQL della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Atharv Guruji 27 aprile 2025, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 221 volte e gli è piaciuto 9 spettatori. Buona visione!

448