密码检查约束SQL服务器(Password check-constraint SQL server)

 我正在尝试创建一个必须包含的密码约束： 
 
 - 至少1个大写字母 
 
 - 至少1个号码 
 
 - 至少5个字符长 
 
 我搜索了很多，但我无法使它工作 
 
 例如，我试过这个 
 
(len([PASSWORD])>(5) AND [PASSWORD] like '%[0-9]%' AND [PASSWORD] like '%[A-Z]%')
 
 现在，如果密码包含一个数字，它会接受它，但是当密码根本没有大写字母时，它也会接受它，或者只有大写字母，这会让我感到困惑，我尝试了很多组合 
 
[password] LIKE '%[^a-zA-Z0-9]%'
 
 这也没有用，我已经尝试了很多来自stackoverflow的代码片段，人们已将其标记为已回答，这让我想知道，这是我的问题还是我做错了什么？ 我现在很困惑 
 
(len([PASSWORD])>(5) AND [PASSWORD] like '%[A-Z]%' AND [PASSWORD] like '%[0-9]%')
 
 这不应该允许密码：“wefwefew123”对吗？ 好吧，确实如此。 虽然它不接受“wefwefew”，所以它确实适用于0-9，AZ有什么问题？ 
 
 这可能是一个愚蠢的错误，我可能会感到愚蠢，但我不能自己解决它，请记住我不是亲;） 

I'm trying to create a password constraint that must contain:
 
-at least 1 Upper case
 
-at least 1 number
 
-at least 5 characters long
 
I have searched a lot and i just can't make it work
 
for example, i have tried this
 
(len([PASSWORD])>(5) AND [PASSWORD] like '%[0-9]%' AND [PASSWORD] like '%[A-Z]%')
 
now, it will accept it if the password contains a number, but it will also accept it when the password contains no capitals at all, or only capitals, this confuses me, and i've tried many combinations
 
[password] LIKE '%[^a-zA-Z0-9]%'
 
that also didn't work, i have tried many code snippets from stackoverflow and people have marked it as answered, this makes me wonder, is it a problem on my part or am i doing something wrong? i am very confused right now
 
(len([PASSWORD])>(5) AND [PASSWORD] like '%[A-Z]%' AND [PASSWORD] like '%[0-9]%')
 
this should not allow the password: "wefwefew123" right? well, it does. it does not accept "wefwefew" though, so it does work with 0-9, what's wrong with the A-Z?
 
It's probably an dumb mistake and i will probably feel dumb after, but i can't solve it on my own, do keep in mind I'm no pro ;)

原文：https://stackoverflow.com/questions/30453111