• Paresh Prajapati (1/20/2009)


    Can have script to generate 16 digit unique number which contain both character/Number..

    which should be not duplicate in future also.

    declare @random varchar(50)

    set @random = newid()

    print (@random)

    select substring(@random,1, 16)

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com