在MS-SQL中是否有等效于SHA1()的东西? [英] Is there an equivalent to SHA1() in MS-SQL?

问题描述

将几个存储过程从MySQL转换为Microsoft SQL Server.一切都进行得很好，除了一个过程使用了MySQL SHA1()函数.我似乎在MS-SQL中找不到与之等效的东西.

Converting a couple stored procedures from MySQL to Microsoft SQL server. Everything is going well, except one procedure used the MySQL SHA1() function. I cannot seem to find an equivalent to this in MS-SQL.

有人知道MS-SQL上SHA1()的有效等效项吗?

Does anyone know a valid equivalent for SHA1() on MS-SQL?

推荐答案

SQL Server 2005和更高版本具有 HashBytes()函数.

SQL Server 2005 and later has the HashBytes() function.

这篇关于在MS-SQL中是否有等效于SHA1()的东西?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！