DECLARE @PwdLen SMALLINT,
@Chr TINYINT,
@Password VARCHAR(20)
-- Seed
SET @Chr = RAND(DATEPART(ms, GETDATE())) * 0
SET @Password = ''
SET @PwdLen = 1
WHILE @PwdLen < 8
BEGIN
SET @Chr = RAND() * 62
SET @Password = @Password + CHAR(
CASE WHEN @Chr < 10 THEN @Chr + 48
WHEN @Chr BETWEEN 10 AND 35 THEN @Chr + 55
ELSE @Chr + 61
END)
SET @PwdLen = @PwdLen + 1
END
SELECT @Password [Password]
Technical Lead with 9+ years of IT experience in application system design and development using Microsoft technology. Worked in Onsite / Offshore setup. Excellent communication skills bridging Client Interaction and Team Management.
Monday, March 31, 2014
Generate a unique alphanumeric password using SQL
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment