22,207
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER [JU_Uint_People_XueliAndZhichengUpdate] ON [dbo].[JU_Unit_People]
FOR UPDATE
AS
IF UPDATE(xueli)
begin
INSERT INTO JU_People_Record(ysxl,id_rl) select xueli,id_rl from Deleted
end
IF UPDATE(ZhiCheng)
begin
INSERT INTO JU_People_Record(yszc,id_rl) select ZhiCheng,id_rl from Deleted
end