SET ANSI_NULLS, QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE dbo.Insert_Login_Role

@Login_Name nvarchar(50),

@First_Name nvarchar(50),

@Last_name nvarchar(50),

@user_Password nvarchar(50),

--@Login_date date,

@Gender nchar(10),

--@Birth_year date,

@Role_Name nvarchar(50)

-- @Role_ID int

--@Role_ID2 int

AS

SET NOCOUNT ON

INSERT INTO [Login] (Login_Name, First_Name, Last_name, user_Password, Login_date, Gender, Birth_year)

OUTPUT @Role_Name, inserted.Role_ID INTO [Role](Role_Name, Role_ID)

VALUES(@Login_Name, @First_Name, @Last_name, @user_Password, '07-05-1990 ', @Gender , '07-04-1990 ')

GO