帮助查询请 [英] Help in Query Please

问题描述

hi


i有2张桌子

emp1和emp2



现在我想要2从emp2插入emp1，这是UID字段包含0值

如果员工已经退出该emp1表，那么它将自动删除并从emp2中新添加

hi
i Have 2 tables
emp1 and emp2

now i want 2 insert in emp1 from emp2 which is UID field contains 0 value
if employee already exit in that emp1 table then it will automatically delete and newly add from emp2

推荐答案

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

在SqlServer存储过程中。

In SqlServer Stored Procedure.

这篇关于帮助查询请的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！