CREATE TRIGGER TR_Update_A ON dbo.A
FOR update
AS
/*
declare @a int
declare @b int
set @a = (select Flag from inserted)
set @b = (select id from inserted)
if @a = 9
begin
update JFInfoTab set Flag = 1 where ID = @b
end
*/
if update(flag)
update JFInfoTab set flag=1
from JFInfoTab a join inserted b on a.id=b.id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货