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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
|
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE InsertRegisterAdresse
-- Add the parameters for the stored procedure here
@Nom varchar(50),
@Prenom varchar(50),
@Email varchar(50),
@Langue varchar(50),
@Password varchar(50),
@Role varchar(50) = 'utilisateur' ,
@Rue varchar(50),
@Numero varchar(50),
@Postcode varchar(50),
@Ville varchar(50),
@Pays varchar(50),
@Type int =1
AS
BEGIN
SET NOCOUNT ON --added to prevent extra result sets from
set xact_abort on
-- interfering with SELECT statements.
SET NOCOUNT ON;
BEGIN TRANSACTION
BEGIN TRY
DECLARE @IdClient int;
-- Insert statements for procedure here
insert into dbo.Client (
[Nom],[Prenom],[Email],[Langue],[Password],[Role]
)
values
(
@Nom ,
@Prenom ,
@Email ,
@Langue ,
@Password ,
@Role
)
SET @IdClient = (SELECT IDENT_CURRENT('Client'))
insert into dbo.Adresse(
Rue,Numero,PostCode,Ville,Pays,IdType,IdCLient
)
values(
@Rue ,
@Numero ,
@Postcode ,
@Ville ,
@Pays ,
@Type,
@IdClient)
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK
END CATCH
END |
Partager