trigger_rkmx_insert.sql

一个powerbuilder开发的进销存系统 比较值得参考的

alter trigger dba.trigger_rkmx_insert on
DBA.ck_rkmxb for insert
--[ REFERENCING NEW AS new_name ]
--FOR EACH ROW
as --[ WHEN( search_condition ) ]
begin
  declare @dh char(10),@c integer
  select @dh = dh from inserted
  select @c = count(dh) from ck_rkzb where dh = @dh
  if @c <> 1
    print '╰参