UC知道请帮我看看这个SQLServer触发器 错在哪里
来源：百度知道 编辑：UC知道 时间：2024/07/05 04:54:55
CREATE TRIGGER update_total ON A
FOR UPDATE
AS
declare @flag int
declare @bh int
select @flag=n_flag,@bh=n_bh from A
if @flag=1
begin
update B set B.n_cpdrs = B.n_cpdrs -1
where B.n_cbh= @bh
end
FOR UPDATE
AS
declare @flag int
declare @bh int
select @flag=n_flag,@bh=n_bh from A
if @flag=1
begin
update B set B.n_cpdrs = B.n_cpdrs -1
where B.n_cbh= @bh
end
CREATE TRIGGER update_total ON A
FOR UPDATE
AS
declare @flag int
declare @bh int
select @flag=n_flag,@bh=n_bh from A--这里把A改成inserted 或者 deleted
if @flag=1
begin
update B set B.n_cpdrs = B.n_cpdrs -1
where B.n_cbh= @bh
end