Possible Duplicate:
Generating random strings with T-SQL
I need to generate a random string with alpha and numeric characters inside a trigger.
The string must have a length of 15 and uppercase.
Someone have an idea?
-
Does it need to be used in a single statement?Joel Coehoorn– Joel Coehoorn2012-12-19 17:03:02 +00:00Commented Dec 19, 2012 at 17:03
-
Possible answer stackoverflow.com/a/74379410/3057246Vinod Srivastav– Vinod Srivastav2023-03-21 22:43:39 +00:00Commented Mar 21, 2023 at 22:43
Add a comment
|
2 Answers
This is far from an optimal solution, but it will work as specified:
select char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)
+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)
+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)
+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)
+char(rand()*26+65)+char(rand()*26+65)+char(rand()*26+65)
Example output:
WCZOVRCIRELAJUT
1 Comment
SWeko
If the length of 15 is set in stone, or if this is part of some test setup, than it's bulletproof.
generate a GUID and take just the first 15 characters?
Generate a bunch of random numbers and translate to their ASCII values?
5 Comments
Joel Coehoorn
Not sure this is a good idea. The first 15 characters of a guid may not be so random... but then again, maybe they'll be random enough.
Limey
@JoelCoehoorn: Could maybe make it fancy and grab the first 6, then the last 5 with with the last 4 coming somewhere from the middle.
paparazzo
Part of the GUID is based on the MAC address would need to avoid that.
jumxozizi
I'm pretty sure that GUID is hashed. There is no fixed part of GUID that would stay the same even on same MAC.
jumxozizi
I think
cast(cast(NEWID() as varbinary(max)) as varchar(max)) is what you are suggesting in this answer. One potential issue is that there will be random special characters like ASCII 0 (null).