Code:
INSERT INTO BackUPTable select * from deleted
INSERT INTO BackUPTable select * from deleted
ALTER TRIGGER [BackUpNotice] ON [dbo].[module_notices] AFTER DELETE AS BEGIN SET NOCOUNT ON DECLARE @fieldname nVARCHAR(100), @value nVARCHAR(MAX), @fields nVARCHAR(2000), @values nVARCHAR(2000), @q nVARCHAR(4000) set @q = 'INSERT INTO deleted_notices SELECT * FROM deleted' exec(@q) END
ALTER TRIGGER [BackUpNotice] ON [dbo].[module_notices] AFTER DELETE AS BEGIN SET NOCOUNT ON DECLARE @fieldname nVARCHAR(100), @value nVARCHAR(MAX), @fields nVARCHAR(2000), @values nVARCHAR(2000), @q nVARCHAR(4000) --DECLARE @t nVARCHAR(MAX) DECLARE get_fieldname CURSOR FOR SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
ALTER TRIGGER [BackUpNotice] ON [dbo].[module_notices] FOR DELETE AS BEGIN DECLARE @fieldname nVARCHAR(100), @value nVARCHAR(MAX), @fields nVARCHAR(2000), @values nVARCHAR(2000), @q nVARCHAR(4000) --DECLARE @t nVARCHAR(MAX) DECLARE get_fieldname CURSOR FOR SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE (TABLE_NAME = 'module_notices')
Leave a comment: