SQL Merge Statement Tutorial A-Z | How to use Merge in SQL step by step guide #sql #dataanalytics

In this video we will understand the SQL merge statement. Using merge statement we can insert , update and delete data in a single statement.
drop table CRM_Customers;
CREATE TABLE CRM_Customers (
CustomerID INT PRIMARY KEY,
Name NVARCHAR(100),
Email NVARCHAR(100),
Status NVARCHAR(50) -- 'Active' or 'Inactive'
);

-- Insert some demo data in CRM_Customers
INSERT INTO CRM_Customers (CustomerID, Name, Email, Status)
VALUES

drop table DW_Customers;
CREATE TABLE DW_Customers (
CustomerID INT PRIMARY KEY,
Name NVARCHAR(100),
Email NVARCHAR(100),
Status NVARCHAR(50),
LastUpdated DATETIME
);

-- Insert existing records into DW_Customers
INSERT INTO DW_Customers (CustomerID, Name, Email, Status, LastUpdated)
VALUES

#sql #merge #sqlqueryinterviewquestionsandanswers
#SQLMergestatement
#HowtouseMergeinSQL
#SQLMergetutorial
#SQLMerge
#SQLQuery
#SQLtutorial
#LearnSQL
#SQLforbeginners
#SQLprogramming