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
| USE SouCredImmo
Go
IF OBJECT_ID('trg_Resume_Emprunteur') IS NOT NULL
DROP TRIGGER trg_Resume_Emprunteur
GO
CREATE TRIGGER trg_Resume_Emprunteur
ON tbl_Referentiel_Dossiers
AFTER UPDATE, INSERT
AS
BEGIN
DECLARE @vch_Resultat varchar(300)
EXECUTE prc_Formulaire_Dossier_Emplois_Lib1 INSERTED.fld_int_Code_Dossier, @vch_Resultat = @vch_Resultat OUTPUT
UPDATE tbl_Referentiel_Dossiers
SET
fld_vch_Resume_Emprunteur = (SELECT @vch_Resultat)
FROM INSERTED
WHERE tbl_Referentiel_Dossiers.fld_int_Code_Dossier = INSERTED.fld_int_Code_Dossier
END
GO |
