Question

MSSQL(SQL Server) MD5 값 구하기

Answer 1

sql server query 로 md5 값 구하기

SELECT CONVERT(VARCHAR(32), HashBytes('MD5','nanumtip.com'),2)

SELECT HashBytes('MD5', 'nanumtip.com')

SELECT SUBSTRING(sys.fn_sqlvarbasetostr(HASHBYTES('MD5','nanumtip.com')),3,32)