ALTER trigger del_consumeItem on T_consumeItem for delete as
begin
declare
@numrows int
select @numrows = @@rowcount
if @numrows = 0
return
if exists(select 1 from t_consume a ,deleted b where a.itemCode=b.itemCode)
begin
RAISERROR ('正在使用的费用项目,不能删除!',16,1)
ROLLBACK TRANSACTION
return
end
end
你是不是想这样子。。