trigger_ckzb_update.sql

来自「一个powerbuilder开发的进销存系统 比较值得参考的」· SQL 代码 · 共 13 行

alter trigger dba.trigger_ckzb_update on
DBA.ck_ckzb for update
--REFERENCING [ OLD AS old_name ]
--        [ NEW AS new_name ]
--FOR EACH ROW
as --[ WHEN( search_condition ) ]
begin
  declare @dh char(10)
  select @dh = dh from inserted
  begin
    update jb_kcb set jb_kcb.kcsl = isnull(jb_kcb.kcsl,0)-ck_ckmxb.sl from ck_ckmxb where ck_ckmxb.dh = @dh and ck_ckmxb.hch = jb_kcb.hch and ck_ckmxb.lh = jb_kcb.lh
  end
end