Skip to main content

Generate HASH string with T-SQL -Sqlserver

Using HASHBYTES Generate HASH string :

HASHBYTES ( '<algorithm>', { @input | 'input' } )   
<algorithm>::= MD2 | MD4 | MD5 | SHA | SHA1 | SHA2_256 | SHA2_512 

 
Algorithm  MD5: 
SELECT CONVERT(VARCHAR(32), HashBytes('MD5', 'code-lake@blogspot.com'),2)
Output: 7A598B534FD42DF41F7725CAAD261DCB

Algorithm SHA1: 
SELECT CONVERT(VARCHAR(32), HashBytes('SHA1', 'code-lake@blogspot.com'),2)
Output: 7141CCD5A09B915B8541D4E4C3DCD108
Reference: MSDN
Labels:

Comments

Post a Comment

Popular posts from this blog

What are the difference between DDL, DML , DCL and TCL commands?

Database Command Types DDL Data Definition Language  (DDL) statements are used to define the database structure or schema.  -           CREATE - to create objects in the database -           ALTER - alters the structure of the database -           DROP - delete objects from the database -           TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed -           COMMENT - add comments to the data dictionary -           RENAME - rename an object DML Data Manipulation Language  (DML) statements are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to d...
2 comments
Read more

Ubuntu/Unix Console Command -Cheat Sheet

M ost popular Linux/Unix command those are required to know during working on Linux/Unix environment. Primarily, when I started the work on ubuntu, I faced a common problem that was not familiar to know about the basic ubuntu command. After that, I aggregate basic commands and work very well. Besides that, most of the time forgot the command and this helps me to cut-down googling time. Privileges SL Command Use / Description 1 sudo command Run command as root 2 sudo -s Open a root shell 3 sudo -s -u user Open a shell as user 4 sudo -k Forget sudo passwords 5 gksudo command Visual sudo dialog (GNOME) 6 kdesudo command visual sudo dialog (KDE) 7 sudo visudo edit /etc/sudoers 8 gksudo nautilus root file man...
Post a Comment
Read more

How to check dotnet SDK and runtime version installed

I need to install dot net SDK 5 but first, I need to know which versions of SDK installed on my system. So, use   dotnet --info .  This command will display the SDKs and also runtimes installed on your system with path together where they are installed. For example on my Windows 10 development machine,  dotnet --info   Microsoft Windows [Version 10.0.18363.1082] (c) 2019 Microsoft Corporation. All rights reserved. C:\WINDOWS\system32>dotnet --info .NET Core SDK (reflecting any global.json):  Version:   3.1.101  Commit:    b377529961 Runtime Environment:  OS Name:     Windows  OS Version:  10.0.18363  OS Platform: Windows  RID:         win10-x64  Base Path:   C:\Program Files\dotnet\sdk\3.1.101\ Host (useful for support):   Version: 3.1.8   Commit:  9c1330dedd .NET Core SDKs installed:   1.0.0-preview2-003131 [C:\Program Files\dotnet\sdk...
Post a Comment
Read more