CREATE TRIGGER SystemLog_CodZonas ON dbo.tbl_gc_CodZonas FOR INSERT, UPDATE, DELETE AS DECLARE @TypeTrans CHAR(6) DECLARE @TRCodigo VARCHAR(16) IF EXISTS(SELECT * FROM inserted) AND EXISTS(SELECT * FROM deleted) SET @TypeTrans = 'UPDATE' ELSE IF EXISTS(SELECT * FROM inserted) SET @TypeTrans = 'INSERT' ELSE IF EXISTS(SELECT * FROM deleted) SET @TypeTrans = 'DELETE' IF @TypeTrans = 'INSERT' BEGIN SET @TRCodigo = (SELECT c_codigo FROM Inserted) INSERT INTO dbo.tbl_system_log (c_tablename,c_accao,c_codigoalt,c_username, d_datetime) VALUES ('dbo.tbl_gc_CodZonas','INSERT',@TRCodigo,suser_sname(), getdate()) END IF @TypeTrans = 'UPDATE' BEGIN SET @TRCodigo = (SELECT c_codigo FROM Inserted) INSERT INTO dbo.tbl_system_log (c_tablename,c_accao,c_codigoalt,c_username, d_datetime) VALUES ('dbo.tbl_gc_CodZonas','UPDATE',@TRCodigo,suser_sname(), getdate()) END IF @TypeTrans = 'DELETE' BEGIN SET @TRCodigo = (SELECT c_codigo FROM deleted) INSERT INTO dbo.tbl_system_log (c_tablename,c_accao,c_codigoalt,c_username, d_datetime) VALUES ('dbo.tbl_gc_CodZonas','DELETE',@TRCodigo,suser_sname(), getdate()) ENDThanks