估计你的意思是当AMOUNT字段被更新为0时让触发器自动删除纪录
Create trigger TRUp on TableName for Update /*Update触发器*/
AS
begin
declare @Amount float
select @Amount=Amount from TableName
if @Amount =0
Delete from TableName where 其他条件End
Create trigger TRUp on TableName for Update /*Update触发器*/
AS
begin
declare @Amount float
select @Amount=Amount from TableName
if @Amount =0
Delete from TableName where 其他条件End
这样可能要好些:
Create trigger TR_Update
ON T
FOR Update
AS
begin
declare @Amount int
select @Amount=Amount from inserted
if @Amount =0
Delete from T where Amount=0
End