--use Trigger Create trigger trigname on 表 for update as if exists(Select * from deleted where a<=0 or b<=0 or c<=0 or c<=0) Rollback tran go
如果>=0的时候我想执行下面这条语句,该如何建触发器,可以传参数进来的吗? update 表 set jf=jf+"+ a +"+"+ b +"+"+ c +"+"+d +",hb=hb-"+ hb +",a=a+"+ a +",b=b+"+ b +",c=c+"+ c +",d=d+"+ d +" where UserName='"+ username +"'";
Create trigger trigname on 表
for update
as
if exists(Select * from deleted where a<=0 or b<=0 or c<=0 or c<=0)
Rollback tran
go
update 表 set jf=jf+"+ a +"+"+ b +"+"+ c +"+"+d +",hb=hb-"+ hb +",a=a+"+ a +",b=b+"+ b +",c=c+"+ c +",d=d+"+ d +" where UserName='"+ username +"'";