if Exists(select name from sysobjects where name='tr') drop trigger tr go create trigger tr on t_xx for insert as declare @a char(4) select @a=aa from inserted if(@aa>1000) begin update t_xx set aa=@aa*0.5 where id=(select id from t_xx order by id desc) end
drop trigger tr
go
create trigger tr on t_xx for insert
as
declare @a char(4)
select @a=aa from inserted
if(@aa>1000)
begin
update t_xx set aa=@aa*0.5 where id=(select id from t_xx order by id desc)
end