MSSQL 암호화 hashbytes / fn_varbintohexstr
/* MD5 */Select Substring(master.dbo.fn_varbintohexstr(hashbytes('MD5', 'abc')), 3, 32) [결과] '900150983cd24fb0d6963f7d28e17f72' /* SHA256 */Select Substring(master.dbo.fn_varbintohexstr(hashbytes('SHA2_256', 'abc')), 3, 64) [결과] 'ba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad' /* MD5 -> cast -> SHA256 */Select Substring(master.dbo.fn_varbintohexstr(hashbytes('SHA2_256', Cast(Su..
프로그래밍/MS-SQL
2016. 11. 29. 11:19