新增
Create TRIGGER [dbo].[T_TriggerName] /[[T_TriggerName]]为触发器名/
ON [dbo].[TableName] /[TableName]为表名/
after insert
AS
Begin
SET NOCOUNT ON;
insert into [TableName_New] select * FROM inserted; /inserted为insert的数据/
end
新增
Create TRIGGER [dbo].[T_TriggerName] /[[T_TriggerName]]为触发器名/
ON [dbo].[TableName] /[TableName]为表名/
after insert
AS
Begin
SET NOCOUNT ON;
insert into [TableName_New] select * FROM inserted; /inserted为insert的数据/
end