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
| CREATE TABLE T
(
Tid Int NOT NULL
, Nom Varchar(32) NOT NULL
, Secret Varchar(32) NOT NULL
, CONSTRAINT T_PK PRIMARY KEY (Tid)
) ;
GO
CREATE VIEW V
AS SELECT Tid, Nom
FROM T
;
GO
CREATE TRIGGER TRG ON V INSTEAD OF INSERT AS
INSERT INTO T
SELECT Tid, Nom, 'Pas touche'
FROM INSERTED
GO
INSERT INTO T VALUES (1, 'Albert', 'top secret') ;
SELECT '' AS 'T1', * FROM T ;
UPDATE V SET Nom = 'Bernard' WHERE Nom = 'Albert'
SELECT '' AS 'T2', * FROM T ;
INSERT INTO V VALUES (2, 'Charles') ;
SELECT '' AS 'T3', * FROM T ; |
Partager