Security HASHBYTES SQL function


1. Usage of HASHBYTES.

SQL Server Query 1

            
 SELECT 'MD2' AS Algorithum,  HASHBYTES('MD2', 'abcdef') AS TerritoryDescriptionHB, LEN(HASHBYTES('MD2', 'abcdef')) AS HBLength  
UNION ALL
SELECT 'MD4' AS Algorithum, HASHBYTES('MD4', 'abcdef') AS TerritoryDescriptionHB, LEN(HASHBYTES('MD2', 'abcdef')) AS HBLength
UNION ALL
SELECT 'MD5' AS Algorithum, HASHBYTES('MD5', 'abcdef') AS TerritoryDescriptionHB, LEN(HASHBYTES('MD5', 'abcdef')) AS HBLength
UNION ALL
SELECT 'SHA' AS Algorithum, HASHBYTES('SHA', 'abcdef') AS TerritoryDescriptionHB, LEN(HASHBYTES('SHA', 'abcdef')) AS HBLength
UNION ALL
SELECT 'SHA1' AS Algorithum, HASHBYTES('SHA1', 'abcdef') AS TerritoryDescriptionHB, LEN(HASHBYTES('SHA1', 'abcdef')) AS HBLength
UNION ALL
SELECT 'SHA2_256' AS Algorithum, HASHBYTES('SHA2_256', 'abcdef') AS TerritoryDescriptionHB, LEN(HASHBYTES('SHA2_256', 'abcdef')) AS HBLength
UNION ALL
SELECT 'SHA2_512' AS Algorithum, HASHBYTES('SHA2_512', 'abcdef') AS TerritoryDescriptionHB, LEN(HASHBYTES('SHA2_512', 'abcdef')) AS HBLength

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  
.Select()
.ColumnWithValue("MD2", "Algorithum")
.Column(new HASHBYTES(HashBytesAlgorithum.MD2, "abcdef"), "TerritoryDescriptionHB")
.Column(new LEN(new HASHBYTES(HashBytesAlgorithum.MD2, "abcdef")), "HBLength")
.UnionAll(new SqlQueryBuilder().Select()
.ColumnWithValue("MD4", "Algorithum")
.Column(new HASHBYTES(HashBytesAlgorithum.MD4, "abcdef"), "TerritoryDescriptionHB")
.Column(new LEN(new HASHBYTES(HashBytesAlgorithum.MD4, "abcdef")), "HBLength")
)
.UnionAll(new SqlQueryBuilder().Select()
.ColumnWithValue("MD5", "Algorithum")
.Column(new HASHBYTES(HashBytesAlgorithum.MD5, "abcdef"), "TerritoryDescriptionHB")
.Column(new LEN(new HASHBYTES(HashBytesAlgorithum.MD5, "abcdef")), "HBLength")
)
.UnionAll(new SqlQueryBuilder().Select()
.ColumnWithValue("SHA", "Algorithum")
.Column(new HASHBYTES(HashBytesAlgorithum.SHA, "abcdef"), "TerritoryDescriptionHB")
.Column(new LEN(new HASHBYTES(HashBytesAlgorithum.SHA, "abcdef")), "HBLength")
)
.UnionAll(new SqlQueryBuilder().Select()
.ColumnWithValue("SHA1", "Algorithum")
.Column(new HASHBYTES(HashBytesAlgorithum.SHA1, "abcdef"), "TerritoryDescriptionHB")
.Column(new LEN(new HASHBYTES(HashBytesAlgorithum.SHA1, "abcdef")), "HBLength")
)
.UnionAll(new SqlQueryBuilder().Select()
.ColumnWithValue("SHA2_256", "Algorithum")
.Column(new HASHBYTES(HashBytesAlgorithum.SHA2_256, "abcdef"), "TerritoryDescriptionHB")
.Column(new LEN(new HASHBYTES(HashBytesAlgorithum.SHA2_256, "abcdef")), "HBLength")
)
.UnionAll(new SqlQueryBuilder().Select()
.ColumnWithValue("SHA2_512", "Algorithum")
.Column(new HASHBYTES(HashBytesAlgorithum.SHA2_512, "abcdef"), "TerritoryDescriptionHB")
.Column(new LEN(new HASHBYTES(HashBytesAlgorithum.SHA2_512, "abcdef")), "HBLength")
)
.Build();

Query build by SqlQueryBuilder 1

            
SELECT @pMAIN_2602032110085349350 AS Algorithum,
       HASHBYTES(@pMAIN_2602032110085349351, @pMAIN_2602032110085349352) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_2602032110085349353, @pMAIN_2602032110085349354)) AS HBLength
UNION ALL
SELECT @pMAIN_2602032110085349355 AS Algorithum,
       HASHBYTES(@pMAIN_2602032110085349356, @pMAIN_2602032110085349357) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_2602032110085349358, @pMAIN_2602032110085349359)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211008534935_10 AS Algorithum,
       HASHBYTES(@pMAIN_260203211008534935_11, @pMAIN_260203211008534935_12) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211008534935_13, @pMAIN_260203211008534935_14)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211008534935_15 AS Algorithum,
       HASHBYTES(@pMAIN_260203211008534935_16, @pMAIN_260203211008534935_17) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211008534935_18, @pMAIN_260203211008534935_19)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211008534935_20 AS Algorithum,
       HASHBYTES(@pMAIN_260203211008534935_21, @pMAIN_260203211008534935_22) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211008534935_23, @pMAIN_260203211008534935_24)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211008534935_25 AS Algorithum,
       HASHBYTES(@pMAIN_260203211008534935_26, @pMAIN_260203211008534935_27) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211008534935_28, @pMAIN_260203211008534935_29)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211008534935_30 AS Algorithum,
       HASHBYTES(@pMAIN_260203211008534935_31, @pMAIN_260203211008534935_32) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211008534935_33, @pMAIN_260203211008534935_34)) AS HBLength;


            
        

Parameters (If used)

Name Value
@pMAIN_2602032110085349350 MD2
@pMAIN_2602032110085349351 MD2
@pMAIN_2602032110085349352 abcdef
@pMAIN_2602032110085349353 MD2
@pMAIN_2602032110085349354 abcdef
@pMAIN_2602032110085349355 MD4
@pMAIN_2602032110085349356 MD4
@pMAIN_2602032110085349357 abcdef
@pMAIN_2602032110085349358 MD4
@pMAIN_2602032110085349359 abcdef
@pMAIN_260203211008534935_10 MD5
@pMAIN_260203211008534935_11 MD5
@pMAIN_260203211008534935_12 abcdef
@pMAIN_260203211008534935_13 MD5
@pMAIN_260203211008534935_14 abcdef
@pMAIN_260203211008534935_15 SHA
@pMAIN_260203211008534935_16 SHA
@pMAIN_260203211008534935_17 abcdef
@pMAIN_260203211008534935_18 SHA
@pMAIN_260203211008534935_19 abcdef
@pMAIN_260203211008534935_20 SHA1
@pMAIN_260203211008534935_21 SHA1
@pMAIN_260203211008534935_22 abcdef
@pMAIN_260203211008534935_23 SHA1
@pMAIN_260203211008534935_24 abcdef
@pMAIN_260203211008534935_25 SHA2_256
@pMAIN_260203211008534935_26 SHA2_256
@pMAIN_260203211008534935_27 abcdef
@pMAIN_260203211008534935_28 SHA2_256
@pMAIN_260203211008534935_29 abcdef
@pMAIN_260203211008534935_30 SHA2_512
@pMAIN_260203211008534935_31 SHA2_512
@pMAIN_260203211008534935_32 abcdef
@pMAIN_260203211008534935_33 SHA2_512
@pMAIN_260203211008534935_34 abcdef

Query Results 1:

  Algorithum TerritoryDescriptionHB Display_TerritoryDescriptionHB HBLength
1 MD2 System.Byte[] 0x8CB92B90800166CD719E9A93E5B26E52 16
2 MD4 System.Byte[] 0xB5FE2DB507CC5AC540493D48FBD5FE33 16
3 MD5 System.Byte[] 0x8AB6523582D89BD285E86A85D178ED5F 16
4 SHA System.Byte[] 0x2EEC0A11782DD531AA9D0FCAC4BBDEF1AF711C84 20
5 SHA1 System.Byte[] 0x2EEC0A11782DD531AA9D0FCAC4BBDEF1AF711C84 20
6 SHA2_256 System.Byte[] 0x5920DEEC20B2AC7028FDCDB5747BB9B601985A67852EA145782255AB2D09EFBD 32
7 SHA2_512 System.Byte[] 0x8857FD09FC8BF4FCADCF26817F146AB29FAD2E2222D47D1E23F18B5DA31F6F08C3F4FF35E5A8D25C579BB30282A942B9C900B295D9F490089270FD9EA0244B7A 64