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
| CREATE TRIGGER creer_adresse_livraison
on xx_clients
FOR INSERT
AS
DECLARE @client_id INT,
@client_nom VARCHAR(20),
@client_prenom VARCHAR(20),
@client_adresse VARCHAR(50),
@client_complement VARCHAR(50),
@client_ville VARCHAR(50),
@client_cp INT,
@client_pays VARCHAR(50),
@livr_intitule VARCHAR(50);
SELECT
@client_id = client_id,
@client_nom = client_nom,
@client_prenom = client_prenom,
@client_adresse = client_adresse,
@client_complement = client_complement ,
@client_cp = client_cp,
@client_ville = client_ville,
@client_pays = client_pays
FROM INSERTED;
SET @livr_intitule = @client_nom + ' - ' + @client_prenom
INSERT INTO xx_livraisons (livr_client_id,livr_intitule,livr_nom,livr_prenom,livr_adresse,livr_complement,livr_cp,livr_ville,livr_pays,livr_edit,livr_sommeil)
VALUES (@client_id,@client_nom,@client_nom,@client_prenom,@client_adresse,@client_complement,@client_cp,@client_ville,@client_pays,0,0); |
Partager