关于触发器中删除的问题?
请问我想将本表中被删除的记录转换到其它表中如何操作?
我当前的操作是这样的:
表1(info) 有以下字段:
id,name,sex,indate
表2(info_del)有以下字段:
id,name,sex,indate,deldate deldate 的默认值是getdate()
我想在删除表1中数据时,将删除后的记录重新写到表2中:
CREATE TRIGGER [delinfo] ON [dbo].[info]
FOR DELETE
AS
DECLARE @id int
DECLARE @name varchar(20)
DECLARE @sex varchar(2)
DECLARE @indate datetime
SELECT
@id = deleted.id,
@name = deleted.name,
@sex = deleted.sex,
@indate = deleted.indate,
FROM info,deleted
INSERT info_del VALUES(@id,@name,@sex,@indate)