Home Forums SQL Server 2005 SQL Server Newbies Random 64 Characters alphanumeric String RE: Random 64 Characters alphanumeric String

  • March 12, 2009 at 8:30 am

    #958365

    jcrawf02 (3/12/2009)

    AFIFM (3/11/2009)

    I need to create a random 64 alphanumeric string every time a new row is added to a SQL 2005 database table. It does not have to be unique.

    What are you doing with this random non-unique string?

    I have an application that takes the user's password and converts it into one-way hash SHA256 64 characters alphanumeric field. We needed to create a second field to use as token (handshake) between two separate applications and I thought I would just use the same thing. If I had to do it from scratch I would have used the newid() function but these are legacy data and it will be cumbersome to change.