你上面的不仅不好,而且在修改多行时还会出错.CREATE TRIGGER [bm_up] ON mt_bum
FOR INSERT,UPDATE
AS
begin
if update(shu_ch)
update tr_chk set shul_mq = shul_qc -shu_ch where id in (select id from inserted)
END
FOR INSERT,UPDATE
AS
begin
if update(shu_ch)
update tr_chk set shul_mq = shul_qc -shu_ch where id in (select id from inserted)
END
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货