Hashing a string - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Hashing a string

Author

Topic

bassem_farouk
Starting Member

18 Posts

Posted - 2010-04-23 : 00:06:48

Hi
I am on SQL Server 8.00.2039 - SP4 (Developer Edition)

I have a string which i need to hash it

how can i do that , i need the hashing to be a known algorithm(type) , so i can encrypt this string in oracle database

Thanks

Thanks

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-04-23 : 01:26:25

From BOL -> Known <algorithm> in sql= MD2 | MD4 | MD5 | SHA | SHA1

DECLARE @HashThis varchar(8000);
SELECT @HashThis = CONVERT(varchar(8000),'dslfdkjLK85kldhnv$n000#knf');
SELECT HashBytes('SHA1', @HashThis);
GO

What are supported alg. in oracle ?

I am here to learn from Masters and help new bees in learning.

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-04-23 : 01:31:57

Sorry.. I just noticed that you are using sql 2000.

I am here to learn from Masters and help new bees in learning.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources