--end 去掉或改为gocreate trigger tr_audit on audit for update
as
if update (acircs)
delete from goods where goods.gid=inserted.gid and inserted.acircs=3
go
as
if update (acircs)
delete from goods where goods.gid=inserted.gid and inserted.acircs=3
go
列前缀inserted与查询中所用的表名或别名不匹配
列前缀inserted与查询中所用的表名或别名不匹配
就多出这两个错误啊!
as
if update(acircs)
delete goods from goods,inserted
where goods.gid=inserted.gid and inserted.acircs=3
go
as
begin
if update (acircs)
delete from goods where goods.gid=inserted.gid and inserted.acircs=3
end