1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
SET @SQL_Create_Trigger = '
USE ['+@DB_Name+']
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N''[dbo].[TRG_01_Log_Modif_'+@TableName+']''))
DROP TRIGGER [dbo].[TRG_01_Log_Modif_T_'+@TableName+']
CREATE TRIGGER TRG_01_Log_Modif_'+@TableName+' ON dbo.'+@TableName+' FOR INSERT, UPDATE, DELETE
AS
DECLARE
@DBName VARCHAR(500),
@Bit INT ,
@Field INT ,
@MaxField INT ,
@Char INT ,
@FieldName VARCHAR(128) ,
@TableName VARCHAR(128) ,
@PKCols VARCHAR(1000) ,
@SQL VARCHAR(2000),
@UpdateDate VARCHAR(21) ,
@UserName VARCHAR(128) ,
@Type CHAR(1) ,
@PKSelect VARCHAR(1000),
@ColumnType VARCHAR(500)
...
'
EXEC (@SQL_Create_Trigger) |
Partager