RE: [ cf-dev ] Random Password - SQL

[Robertson-Ravo, Neil (RX)]

Cheers Adrian I will give it a whirl...I just cross posted to another
list...sorry guys, I gave up on a reply ;-)

-----Original Message-----
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 17 July 2003 11:33
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Random Password - SQL


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]

-- 
** 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]