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 36
| CREATE TRIGGER le_trigger
ON la_table
AFTER UPDATE
AS
IF UPDATE (colonne1) AND UPDATE(colonne2)
BEGIN
DECLARE @col TABLE
(
ID INT IDENTITY,
@col1 VARCHAR(20),
@col2 INT,
@col3 INT
);
DECLARE @i INT; SET @I = 1;
DECLARE @nb_rows INT;
INSERT @col
SELECT @col1 = colonne1,
@col2 = colonne2,
@col3 = colonne3
FROM INSERTED
WHERE @col1 = 'abc'
AND @col2 = 'cba'
WHILE @i <= @nb_rows
BEGIN
BEGIN TRY
EXEC procedure_stockee @col3
END TRY
BEGIN CATCH
-- Gestion des erreurs ...
END CATCH;
SET @i = @i + 1;
END;
END; |
Partager