tags:

views:

4535

answers:

4
+8  Q: 

Is there an equivalent to SHA1() in 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.

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

+20  A: 

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

Joel Coehoorn  2008-10-08 19:31:54
Looks perfect, answered while I took a leak. I love stackoverflow. Thanks!
Geoffrey Chetwood  2008-10-08 19:34:00
Now if they'd just get support for a 256-bit algo instead of only 160
Joel Coehoorn  2008-10-08 19:41:41
+1  A: 

These guys look like they have a solution that includes it.

tloach  2008-10-08 19:33:45
forget your link?
Joel Coehoorn  2008-10-08 19:34:29
@Joel: Thanks, double-double-quoted it. That's what I get for spending too much time with vbscript
tloach  2008-10-08 19:36:15
Interesting, but I like Joel's built in function.
Geoffrey Chetwood  2008-10-08 19:36:42
@Rich: I assumed from your question that you were looking for SHA1, not just any hash function
tloach  2008-10-09 17:23:11
@tloach: If you follow the link, you will see there is SHA1 in the HashBytes() function.
Geoffrey Chetwood  2008-10-20 16:49:56
+2  A: 

From google groups - A Possibility

Jason Lepack  2008-10-08 19:34:20
A: 

I don't believe there's native support, but you may want to check this out...

http://blogs.msdn.com/sqlcat/archive/2005/09/16/469257.aspx

theraccoonbear  2008-10-08 19:34:39

related questions

Remove Quotes and Commas from a String in MySQL
What's the best way of converting a mysql database to a sqlite one?
How do you manage databases in development, test, and production?
Multiple foreign keys?
Add 1 to a field (MySQL)
Issues using MS Access as a front-end to a MySQL database back-end?
Bigger than a char but smaller than a blob
How do I retrieve my MySQL username and password?
Long-time LAMP Developer moving to VB.NET
How do I Concatenate entire result sets in MySQL?
Full complete MySQL database replication? Ideas? What do people do?
SQL: Distribution of table in time
SQLite vs MySQL
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Multiple Updates in MySQL
MySQL/Apache Error in PHP MySQL query
What all do I need to escape when sending a (My)SQL query?
Auto Generate Database Diagram MySQL
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
Python and MySQL
SQL Server 2005 implementation of MySQL REPLACE INTO?
How to export data from SQL Server 2005 to MySQL
Throw Error In MySQL Trigger
Binary Data in MySQL