Transact-SQL: creare un password di caratteri casuali
Si può fare utilizzando SELECT TOP 1 … ORDER BY NEWID(), da una tabella contenente i caratteri disponibili. Ecco l’esempio:
WITH char_table AS ( SELECT 'a' AS a UNION SELECT 'b' AS a ... /* inserire qui l'elenco dei caratteri che si vogliono prendere in considerazione */ ... UNION SELECT 'z' AS a ) SELECT (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) + (SELECT top 1 a FROM char_table ORDER BY newid()) |
Leave a Reply