I don't know if it works on SS7, I can't see any code that would suggest it
would fail, see what you think.
Ade
CREATE PROCEDURE randomPassword
@passwordLength INT,
@password VARCHAR(50) OUTPUT
AS
BEGIN
DECLARE
@errorCode INT,
@counter INT,
@charGroup INT -- Variable to determine which group of
characters to get a random value from
SET @password = ''
SET @counter = 0
WHILE @counter < @passwordLength
BEGIN
SET @charGroup = CAST( RAND() * 3 AS INT ) -- returns 0, 1
or 2
IF @charGroup = 0
BEGIN
-- This will create a random number between 48 and
57 inclusive and hence a character between 0 and 9
SET @password = @password + CHAR( CAST( (58 - 48) *
RAND() AS INT ) + 48 )
END
ELSE IF @charGroup = 1
BEGIN
-- This will create a random number between 65 and
90 inclusive and hence a character between A and Z
SET @password = @password + CHAR( CAST( (91 - 65) *
RAND() AS INT ) + 65 )
END
ELSE IF @charGroup = 2
BEGIN
-- This will create a random number between 97 and
122 inclusive and hence a character between a and z
SET @password = @password + CHAR( CAST( (123 - 97) *
RAND() AS INT ) + 97 )
END
-- Increment WHILE loop counter
SET @counter = @counter + 1
END
SELECT @errorCode = @@ERROR
IF @errorCode <> 0
BEGIN
GOTO ERROR_EXIT
END
GOTO PROCEDURE_EXIT
ERROR_EXIT:
RETURN @errorCode
PROCEDURE_EXIT:
RETURN @errorCode
END
-----Original Message-----
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 17 July 2003 10:32
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] Random Password - SQL
Anyone got a random password generator for SQL so I can use it within an SP?
Cant seem to find one anywhere
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
