SQL2005写个触发器，来个写例子的。不是讲道理的。

[Comeonzhou]

表1 Detail,
表2 Detail_bak
表2是对表1的备份，表2的字段比表1多出了3个字段 ：newid,时间，类型标识（插入/修改/删除）
要求：
在表Detail进行插入的时候，对表Detail_bak进行插入操作，时间取当前。类型标识为插入;
在表Detail进行修改的时候，对表Detail_bak进行插入操作，时间取当前。类型标识为修改；
在表Detail进行删除的时候，对表Detail_bak进行插入操作，时间取当前。类型标识为删除。
所有对Detail进行的操作对应的对Detail_bak都是插入。

[fa_ge]

太简单了，自己写吧

[telankes2000]

SP大大总是一针见血！

[chen_ya_ping]

create table sql:

USE [TestDB]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Person](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](30) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

USE [TestDB]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Person_Back](
	[name] [varchar](30) NOT NULL,
	[backid] [uniqueidentifier] NOT NULL,
	[operatetype] [varchar](10) NOT NULL,
	[operatetime] [datetime] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Person_Back] ADD  DEFAULT (newid()) FOR [backid]
GO

ALTER TABLE [dbo].[Person_Back] ADD  DEFAULT (getdate()) FOR [operatetime]
GO

create trigger sql:

USE [TestDB]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create trigger [dbo].[person_update]
on [dbo].[Person]
after update
as 
--记录到person_back中的是update前的值，如果要update后的name值可以使用from inserted
	insert into person_back(name,operatetype)
	select name,'update' from deleted

GO

USE [TestDB]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create trigger [dbo].[trigger_Person]
on [dbo].[Person]
after insert,delete
as 
  insert into person_back(name,operatetype)
  select name,'delete' from deleted 
  
  insert into person_back(name,operatetype)
  select name,'insert' from inserted 
  

GO

[专注研发ERP低代码开发平台]

------插入-----------
create trigger ti_Detail on Detail after insert
as
if @@rowcount=0 return
set nocount on
 insert into Detail_bak(...) 
	select ...,newid(),getdate(),'insert' from inserted 
set nocount off

------修改-----------
create trigger tu_Detail on Detail after update
as
if @@rowcount=0 return
set nocount on
 insert into Detail_bak(...) 
	select ...,newid(),getdate(),'update' from inserted 
set nocount off

------删除-----------
create trigger td_Detail on Detail after delete
as
if @@rowcount=0 return
set nocount on
 insert into Detail_bak(...) 
	select ...,newid(),getdate(),'delete' from deleted 
set nocount off

[Comeonzhou]

你鄙视个卵 级高了不起啊。

[Comeonzhou]

[Quote=引用 4 楼 sp1234 的回复:]
想讲道理也没有什么可讲，你根本不需要。
[/Quote]
不要JJWW，你是牛人又怎么了。我问我的问题 你可以不回答。

[JiuchunYoung]

[Quote=引用 10 楼 wggfcusmq 的回复:]
SQL code


------插入-----------
create trigger ti_Detail on Detail after insert
as
if @@rowcount=0 return
set nocount on
insert into Detail_bak(...)
select ...,newid(),getdate(),'insert'……
[/Quote]

都不错 给你答案了 呵呵

[Comeonzhou]

在线等。

[vrhero]

自己去看MSDN...道理例子都有...

CREATE TRIGGER (Transact-SQL)

使用触发器

[Comeonzhou]

来个写现成答案的、

[以专业开发人员为伍]

想讲道理也没有什么可讲，你根本不需要。

[谁盗用了我的笨妞]

[Quote=引用 4 楼 sp1234 的回复:]

想讲道理也没有什么可讲，你根本不需要。
[/Quote]