Code --当外修改TEST表中的F1字段时,同时根据条件修改F2字段 ALTERTRIGGER[dbo].[updatetest1]ON[dbo].[TEST] FORINSERT, UPDATE, DELETE AS begin
ifupdate(F1) declare @fidint, @f1int
set@fid=(select fid from inserted) --获取被修改行ID set@f1=(select f1 from inserted) --获取修改后内容 begin if (select f1 from inserted) >0 begin update test set f2 ='5'where fid =@fid end if (select f1 from inserted) <=0 begin update test set f2 ='6'where fid =@fid end end end