1.--建立记录时间表 if object_id('RecordLastDate') is not null drop table RecordLastDate go create table RecordLastDate(tbname varchar(50),lastdate datetime) insert into RecordLastDate select name,null from sysobjects where type='u' and status >=0 and name<>'RecordLastDate' go 2.--建立用户表 if object_id('tb_test') is not null drop table tb_test go create table tb_test(c1 varchar(10)) go 3.--建立触发器 if object_id('tr_1') is not null drop trigger tr_1 go create trigger tr_1 on tb_test for insert,delete as if exists(select 1 from inserted) or exists(select 1 from deleted) update RecordLastDate set lastdate=getdate() where tbname='tb_test' go 4.--测试插入记录 insert tb_test values('abc') insert tb_test values('def') 5.--查看时间记录表 select * from RecordLastDate where tbname='tb_test' go waitfor delay '00:00:05' go 6.--测试删除记录 insert tb_test values('def') --查看时间记录表 select * from RecordLastDate where tbname='tb_test' go --查看结果 /* tbname lastdate ----------------------------------------------- tb_test 2015-08-11 15:25:37.107 tbname lastdate ----------------------------------------------- tb_test 2015-08-11 15:25:42.123 */