不对,应该这样CREATE TRIGGER [New_Plat] ON [dbo].[submitdb]
FOR UPDATE
AS
if update(submitover)
begin
update x
set qe_re=case when i.submitover='1' then 'OK' else 'Failed' end
from akrail_xf.dbo.jwd_queue x,inserted i
where x.qe_id=i.qeid
end
FOR UPDATE
AS
if update(submitover)
begin
update x
set qe_re=case when i.submitover='1' then 'OK' else 'Failed' end
from akrail_xf.dbo.jwd_queue x,inserted i
where x.qe_id=i.qeid
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货