Hi,
You can use below methods for this
1.
IF NOT EXISTS( SELECT * FROM TABLENAME WHERE ID = @NewId)
BEGIN
END
ELSE
BEGIN
END
2.
MERGE INTO Target as t
USING Source as s
ON t.ID = s.ID
WHEN MATCHED THEN
UPDATE SET t.Name = s.Name, t.Address = s.Address
WHEN NOT MATCHED BY TARGET THEN
INSERT (Id, Name, Address)
VALUES (s.Id, s.Name, s.Address)
WHEN NOT MATCHED BY SOURCE THEN
DELETE OUTPUT$action, inserted.id, deleted.id