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 37 38 39 40 41 42 43 44 45 46 47 48 49 50
|
create table MaTable(
a int not null,
b int not null
)
GO
create table regles(
a int not null,
b int not null
)
GO
--insertion des valeurs acceptée
insert into regles (a,b) values
(1,1),
(1,2),
(1,3),
(2,3),
(2,4)
GO
CREATE TRIGGER trg_MaTable
ON MaTable
AFTER INSERT, UPDATE
AS
BEGIN
IF(EXISTS(
SELECT *
FROM INSERTED I
LEFT OUTER JOIN regles R
ON I.a = R.a
AND I.b = R.b
WHERE R.a IS NULL
)
)
BEGIN
RAISERROR('Valeurs incorrectes', 10, 0)
ROLLBACK
END
END
GO
--test du trigger :
insert into MaTable(a,b) values
(1,2), --ok
(1,4) --ko |
Partager