使用触发器记录数据库删除操作

--创建日志表
if(OBJECT_ID('log', 'U') is not null)
	drop table log
	
go
create table log(
	action varchar(20),
	userhost varchar(20),
	createDate datetime default getDate(),
	testid int
)

--创建触发器
go
if(exists (select * from sys.objects where name='test_tgr'))
	drop trigger test_tgr

go
create trigger test_tgr
on test
after insert
as
	declare @id int;
	select @id = id from inserted;
	--记录操作主机名，操作时间，被删除行的id
	insert into log values('insert', host_name(), getDate(), @id)
	print 'insert one'