SQL Server MERGE statement

merge_lookups.sql

MERGE INTO Lookups AS Target
USING (VALUES
  (0, N'Lookup Number 0'),
  (1, N'Lookup Number 1'),
  (2, N'Lookup Number 2'),
  (3, N'Lookup Number 3'),
  (4, N'Lookup Number 4'),
  (5, N'Lookup Number 5'),
  (6, N'Lookup Number 6')
)
AS Source (id, Name)
ON Target.LookupsID = Source.id
-- update matched rows
WHEN MATCHED THEN 
UPDATE SET Name = Source.Name
-- insert new rows
WHEN NOT MATCHED BY TARGET THEN
INSERT (LookupsID, Name)
VALUES (id, Name)
-- delete rows that are in the target but not the source
WHEN NOT MATCHED BY SOURCE THEN
DELETE;