SQL Merge Statement Tutorial A-Z | How to use Merge in SQL step by step guide
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
(101, 'Alice Green', '[email protected]', 'Active'),
(102, 'Mark Smith', '[email protected]', 'Active'),
(103, 'David Clark', '[email protected]', 'Active');
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
(101, 'Alice Green', '[email protected]', 'Active', '2024-10-01'),
(102, 'Mark Smith', '[email protected]', 'Active', '2024-10-01'),
(104, 'Mark Amith', '[email protected]', 'Active', '2024-10-01');
#sql #merge #sqlqueryinterviewquestionsandanswers
#SQLMergestatement
#HowtouseMergeinSQL
#SQLMergetutorial
#SQLMerge
#SQLQuery
#SQLtutorial
#LearnSQL
#SQLforbeginners
#SQLprogramming