触发器

alter TRIGGER  trg_HREMP ON HREMP  instead of INSERT,UPDATE,delete as begin

declare @ast int select @ast=9 if(@ast=1) begin insert into HREMP values('000030','6','','','',GETDATE())

select * from inserted

insert into HREMP select * from inserted end select * from inserted end

insert into HREMP values('000031','6','','','',GETDATE())