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