ALTER procedure [dbo].[spusersignup] @UserName nvarchar(50), @Password nvarchar(50), @Email nvarchar(50), @PhoneNumber nvarchar(50) as Insert into [Users](UserName,Password,UserTypeID,CreateDate,Email,PhoneNumber) values(@UserName,@Password,2,GETDATE(),@Email,@PhoneNumber)
SELECT CreateDate FROM Users WHERE UserName = @UserName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)