alter procedure GetPasswordSp (
@pUsername nvarchar(50),
@pPasswordClear nvarchar(15),
@pPassword char(50) output
)
AS
if @pusername is null
RETURN
set @pPassword = SUBSTRING(master.dbo.fn_varbintohexstr(HASHBYTES('SHA1', ltrim(rtrim(@pPasswordClear)))),3,50)
RETURN
master.dbo.fn_varbintohexstr(CAST(ltrim(rtrim('@pPasswordClear')) AS varbinary))
master.dbo.fn_varbintohexstr(CAST(ltrim(rtrim('@pPasswordClear')) AS varbinary))
DECLARE @pPasswordClear VARCHAR(100) = 'Buckwheat';
DECLARE @pPassword VARCHAR(1000);
SELECT master.dbo.fn_varbintohexstr(CAST(ltrim(rtrim('@pPasswordClear')) AS VARBINARY))
SELECT master.dbo.fn_varbintohexstr(CAST(ltrim(rtrim(@pPasswordClear)) AS VARBINARY))
EXEC GetPasswordSP 'username', @pPasswordClear, @pPassword OUT;
SELECT @pPassword;
0x407050617373776f7264436c656172
0x4275636b7768656174
3fccee01b0d8b57dd132dd2d6953d5cbc80146bf
ALTER PROCEDURE GetPasswordSp (
@pUsername NVARCHAR(50)
, @pPasswordClear NVARCHAR(15)
, @pPassword VARCHAR(50) OUTPUT
)
AS
BEGIN
IF @pusername IS NULL
RETURN
SET @pPassword = SUBSTRING(master.dbo.fn_varbintohexstr(HASHBYTES('SHA1', ltrim(rtrim(@pPasswordClear)))), 3, 50)
END
GO
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
Note that 'something' is a varchar; N'something' is nvarchar.