c#开发笔记-数据库触发器备用表

c#开发笔记-数据库备份表

删除主表数据时自动插入备用表

CREATE TRIGGER [dbo].[Pcm_Table1_Del]
ON [dbo].[Untitled]
WITH EXECUTE AS CALLER
FOR INSERT
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;
delete Pcm_Table1 where DATEDIFF(day,F_CreateDate,GETDATE())>10
    -- Insert statements for trigger here
 
END
GO