begin try
begin tran
delete from emp1 where empid in
(
select empid from emp2
)
insert into emp1
select * from emp2 where empid not in
(
select empid from emp1
)
commit tran
end try
begin catch
rollback tran
raiserror('transaction failed !', 16, 255)
end catch