Understand that English isn't everyone's first language so be lenient of bad spelling and grammar. Back To Top.
Raymond Chen has a great blog post that explains how GUIDs are made and why substrings are not necessarily unique. Try not to break everything. More later. Yeah, I guess your correct.
NEWID is not considered random enough for secure passwords, so depending on your requirements you do need to be careful. Kevin O Kevin O 161 1 2. I needed to generate just three random alphanumeric characters for an ID, but it could work for any length up to 15 or so.
Random is not unique: Posted 1-Aug-12 4: The below code will generate the password and store to the table. Read the question carefully.
You can't edit HTML code. Ask a Question. Quoted Text. Posted 1-Aug-12 2: Treat my content as plain text, not as HTML. Paste as-is. You can't edit other topics. I also wanted a way to explicitly call out excluded characters.
To further enhance the process, we can write the password to a table, so we can generate a bunch of passwords.
If you wanted to generate a pseudorandom alphanumeric string using T-SQL, how would you do it? Some guidelines for posting questions...