자료/MS-SQL

MSSQL 암호화 hashbytes / fn_varbintohexstr

네오블루 2016. 11. 29. 11:19

/* 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(Substring(master.dbo.fn_varbintohexstr(hashbytes('MD5', 'abc')), 3, 32) as varchar(32)))), 3, 64)

  

[결과] '2c89b7e560fb8c30d1c61408e91e4a84934ff0d24e68e51a6fdb744a1bb717fe'