Sql 密码生成器 - 8 个字符，上下并包括一个数字

作者: 妹妹有点紧
来源: 51数据库
2022-10-21

问题描述

我需要在 TSQL 中创建一个新密码，该密码必须为 8 个字符 (a-z)，其中必须包括大写和小写字符以及至少一个数字.

I need to create a new password in TSQL which needs to be 8 characters (a-z) which have to include upper and lower characters as well as at least one number.

谁能帮我解决这个问题?

Can anyone help me with this?

推荐答案

select cast((Abs(Checksum(NewId()))%10) as varchar(1)) + 
       char(ascii('a')+(Abs(Checksum(NewId()))%25)) +
       char(ascii('A')+(Abs(Checksum(NewId()))%25)) +
       left(newid(),5)
from yourTable

推荐阅读