sql server - Generate MD5 hash string with T-SQL

Question

posted Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Is there a way to generate MD5 Hash string of type varchar(32) without using fn_varbintohexstr

SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'email@dot.com')), 3, 32)

So it could be used inside a view with SCHEMABINDING

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Reply

深蓝 · Answer 1 · 2021-10-17T00:56:23+0000

replyed Oct 17, 2021 by 深蓝 (71.8m points)

CONVERT(VARCHAR(32), HashBytes('MD5', 'email@dot.com'), 2)

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…