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
|
CREATE TABLE TEST
(
IDTest INT IDENTITY CONSTRAINT PK_TEST PRIMARY KEY,
val INT NOT NULL,
DateCreation DATETIME NOT NULL CONSTRAINT DF_TEST_DateCreation DEFAULT GETDATE(),
DateModification DATETIME
)
GO
INSERT INTO dbo.TEST (val, DateModification) VALUES (1, GETDATE())
WAITFOR DELAY '00:00:05'
INSERT INTO dbo.TEST (val, DateModification) VALUES (2, GETDATE())
WAITFOR DELAY '00:00:05'
INSERT INTO dbo.TEST (val, DateModification) VALUES (3, GETDATE())
GO
SELECT *
FROM dbo.TEST
GO
-- Maintient la date de modification
CREATE TRIGGER TR_AU_TEST
ON dbo.TEST
AFTER UPDATE
AS
BEGIN
UPDATE dbo.TEST
SET DateModification = GETDATE()
FROM dbo.TEST T
JOIN INSERTED I ON I.IDTest = T.IDTest
END
GO
UPDATE dbo.TEST
SET val = 8
WHERE IDTest = 1
GO
SELECT *
FROM dbo.TEST
GO |
Partager