[SQL]MSSQL各版本密码HASH

SELECT example, pwdencrypt(example)  
FROM  
(SELECT 'carlos' AS example
UNION ALL SELECT 'test'  
UNION ALL SELECT 'test1'  
UNION ALL SELECT 'test2'  
UNION ALL SELECT 'Paul'  
UNION ALL SELECT 'DBAmaster'  
UNION ALL SELECT 'database'  
UNION ALL SELECT 'jhl9mqe5'  
UNION ALL SELECT 'coldfusion'  
UNION ALL SELECT 'sql2005'  
) dvExample

SQL 2005

carlos    0x0100A46130E3D927B05EB2DE879675FDF1DA00E9F8724C8E3764  
test    0x010084E872D2BAC3E6D222F67A9B6BE4EE7E7EF2C3A965CD2328  
test1    0x01002763AD50AE511F9D56DFE9BC531F4F3290A23EB1E674A0B1  
test2    0x0100674BA886B820C88665F44D8C69EB4D78986BCF2F6D512E1E  
Paul    0x0100C29C639AC0F8F6103FE50508DA0525D508717A88EB3CA7C6  
DBAmaster    0x010026B4364314E187FF87FACB357857D54E404F594DE655A85C  
database    0x0100833BF114C602A79637AD149E316CB33E140BBE4D884B1EBA  
jhl9mqe5    0x010002C93EFFA6EA7A73CB84208190DC39C2C3405234F249EDE7  
coldfusion    0x010054197BB70349E52B12D32C78E3DD3E21C4C615A3C77BF106  
sql2005    0x010025E62EF81A9D0864F309EFFFE5165B6E7435AB439AE79360  

SQL 2008

carlos    0x0100E5B36281400285FDD0970CFB962F33B03129CA251E8A3367  
test    0x010042E7DE9F60D8A01D0C0FEF1F99D0594F39BC6E5645C9CAB4  
test1    0x010052283F99DF08B516742B46958250EFC3D29C1C51ED96C727  
test2    0x01002BAE68B3DA95F2100E372B49BDF6B3CD16D4C8FB3C8B546A  
Paul    0x0100B4479CF60A95DE6E5E06D23AFAAE5E094B466FD53D0FA6A2  
DBAmaster    0x010043FA5EB44772086E1C3DDF9283CC4960EDA8B833FB4D0AE6  
database    0x0100528271320C39700387A21006A0567833D27221C3ADA61AB3  
jhl9mqe5    0x010048A898E246CDB7751E86B436362ADD2775C9ACBF3FA78942  
coldfusion    0x01002BC86273C996F8A41F94D94C13E8D00134CA707DAA0583E0  
sql2005    0x0100AA88CA59AFED18B898AC9FF009A409E64EDFA1975254A3A7  

SQL 2012

carlos    0x0200DC91AFDAB100721A8C567C0A1B87E3498C4D98C9A1A09D6874489776BD920B914A65B15AA9CA28FD9C6BC343588313B6A5395B538DE9842534ECCE6B634FEAB9D2E4D203  
test    0x02009A32FD02F4923B4CD24641266E93683E1CCD7032937BF4DC26449F514DD804C69405D00012B7FEDA00A840E54F665448F361EEA17C2FA31B255BD9EF90154B69AF26E84A  
test1    0x020098FE7E1AC26FA531A98ABA70BC0951C5BE2077CBB2AF20AD310764E3397D7E78DC28B666878AF13561C2B5A27F80C368B7D8BA38FC08E32C52CF0566EDAFDE173B68C144  
test2    0x0200F1050CE28C1BA7E7EDF4C83A2587919075A54C0B9D40CD4054740E4615844543995137791F0264D8BC34CD773549D1B69A04D343FA33AA780F5693C645BB759AB52D127B  
Paul    0x0200743EF4A6E2AE58B17295E4FFCEBBAA07E10957262E354FF5236C558EE36F9612DED69D2F2A6C998A55031B04DB24E0FFA5F732C310D2F0D6EB2905FFB8A63E52112B55E8  
DBAmaster    0x0200693F3A36499BABDFCC327056FCEE0E1CB44FEB883025CDC4BD6A227F73B71E4EC4BFB6CF5F57F6355840AF9F4766DDCDD74B33267EEA77B307BB0DB59C8F3FFA54822840  
database    0x020053EB6E8397E93D8C5B653D6A57AA965AB8CFD6E45BAF5097212B7D60B08376B350A24F5455D0BDC1C396C8B3BCC9FCCA2A6137B3DC7CC6029401F7F6406D77FCCE7A1631  
jhl9mqe5    0x020040E24C541543DC00B70ECCDB98E904E706169334B831424429B7E02EF645BBC85316FFA6AEDF83EBE510687766234C402F745318D151046B4E8A71AB5E25A79252E34141  
coldfusion    0x020079845D4DA6FA892286CB53EB2018CF72FE4C417DB631A1A8614A387A8B7C50972C970B03E50D2CCF92E4502A41E756C8A439AE4DA6AAF76F597482045B88599F2B848A92  
sql2005    0x0200A9EAA2CB25FFF09983E2A77309CD5A6773FECB3D340E27625D1F4A78980145534BE3FC6DF19DBFEDBB1EE458FC5BA6759A87A757C39CF76C684486D77F4A5D815D74B8AC  

转自K8博客

zhutougg

继续阅读此作者的更多文章