dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Nov 13, 2018

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Using the HASHBYTES Function in SQL

The HASHBYTES function returns the MD2, MD4, MD5, SHA, SHA1, or SHA2 hash of a string. The next example returns a SHA1 hash value of it the string that was input.

DECLARE @Hash nvarchar(4000);
SET @Hash = CONVERT(nvarchar(4000),'abcdefghijklmnopqrstuvwxyz1234567890');
SELECT HASHBYTES('SHA1', @Hash);

The SHA1 hash value is:

0x13E4284CDEBC43B9CF5D544D6064FE537195E4FC

 

Visit the DevX Tip Bank

 

Hannes Du Preez
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date