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
|
ALTER TRIGGER UpdateLOSSDET
ON dbo.LOSSDET
AFTER UPDATE
AS
BEGIN
DECLARE @oldName VARCHAR(25), @newName VARCHAR(25),
@lossid VARCHAR(15), @typeperteid varchar(10)
SELECT @lossid = (SELECT LossID FROM deleted)
SELECT @oldName = (SELECT Redacteur FROM deleted)
SELECT @newName = (SELECT Redacteur FROM inserted)
SELECT @typeperteid = (SELECT TypePerteID FROM inserted)
if (@typeperteid = 12)
BEGIN
if (@oldName != @newName)
BEGIN
UPDATE DROITS_PDAC set UserID = @newName
where DROITS_PDAC.LossID = @lossid and DROITS_PDAC.LeNiveau = 5
END;
else
BEGIN
RETURN
END
END;
else
BEGIN
RETURN
END;
END |
