Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
17
Reply
Encrypted password is not saving in table column
Sivakumar
Sep 29 2015 3:23 AM
550
Reply
Hi,
This is my stored procedure :
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[uspAddMember]
@MemberName NVARCHAR(50),
@LoginName NVARCHAR(50),
@LoginPassword NVARCHAR(4000)
AS BEGIN
DECLARE @HashThis nvarchar(4000);
SET @HashThis = CONVERT(nvarchar(4000),@LoginPassword);
SELECT HASHBYTES('SHA2_256', @HashThis);
DECLARE @MemberID INT;
INSERT INTO Member(MemberName, LoginPassword)
VALUES(@MemberName, @HashThis);
SET @MemberID = SCOPE_IDENTITY();
INSERT INTO MemberLogin(MemberID, MemberLoginName)
VALUES(@MemberID, @LoginName);
RETURN @MemberID;
END
when I execute this procedure generate a encrypted password but not saving in table column.
Please give me a correct query for that.
Thank you.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
17
)
Next Recommended Forum
error while connecting to sql server
SQL database