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 43 44 45 46 47 48 49
|
ALTER PROCEDURE [dbo].[web_inscription]
(
@email varchar(100),
@password varchar(50),
@prenom varchar(50),
@nom varchar(50),
@sexe int,
@civil int,
@etude int,
@status int,
@experience int,
@connu int,
@code varchar(50)
)
AS
BEGIN
DECLARE @ind_code int
INSERT INTO individu
(
ind_email,
ind_password,
ind_prenom,
ind_nom,
sex_code,
etaciv_code,
nivetu_code,
stapro_code,
exppro_code,
conate_code
)
VALUES
(
@email,
@password,
@prenom,
@nom,
@sexe,
@civil,
@etude,
@status,
@experience,
@connu
)
SELECT @ind_code = SCOPE_IDENTITY()
INSERT INTO code_mail (codmai_libelle, ind_code)
VALUES (@code, @ind_code)
END |
Partager