CREATE TRIGGER tI_ICCardOutOilBillInfo ON dbo.ICCardOutOilBillInfo
FOR INSERT
AS
begin
Declare @tab_name_ICCardOutOilBillLog nvarchar(200),
@cmd_inst_str nvarchar(2000),
@UnPostSapLogID nvarchar(20)
if @@trancount >0
save transaction trans_a
else
begin transaction trans_a
-- select * into table_temp from inserted
select * into #table_temp from inserted
--将新记录插入相应的历史表
if exists (select * from dbo.sysobjects where id = object_id( @tab_name_ICCardOutOilBillLog) and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
select @cmd_inst_str = 'insert into '+@tab_name_ICCardOutOilBillLog +' select * from #table_temp'
execute (@cmd_inst_str)
end
else
begin
select @cmd_inst_str = 'select * into '+@tab_name_ICCardOutOilBillLog + ' from #table_temp'
execute (@cmd_inst_str)
end
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ICCardOutOilBillInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ICCardOutOilBillInfo]
GO