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_2602032112425796760 AS Algorithum,
       HASHBYTES(@pMAIN_2602032112425796761, @pMAIN_2602032112425796762) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_2602032112425796763, @pMAIN_2602032112425796764)) AS HBLength
UNION ALL
SELECT @pMAIN_2602032112425796765 AS Algorithum,
       HASHBYTES(@pMAIN_2602032112425796766, @pMAIN_2602032112425796767) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_2602032112425796768, @pMAIN_2602032112425796769)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211242579676_10 AS Algorithum,
       HASHBYTES(@pMAIN_260203211242579676_11, @pMAIN_260203211242579676_12) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211242579676_13, @pMAIN_260203211242579676_14)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211242579676_15 AS Algorithum,
       HASHBYTES(@pMAIN_260203211242579676_16, @pMAIN_260203211242579676_17) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211242579676_18, @pMAIN_260203211242579676_19)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211242579676_20 AS Algorithum,
       HASHBYTES(@pMAIN_260203211242579676_21, @pMAIN_260203211242579676_22) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211242579676_23, @pMAIN_260203211242579676_24)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211242579676_25 AS Algorithum,
       HASHBYTES(@pMAIN_260203211242579676_26, @pMAIN_260203211242579676_27) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211242579676_28, @pMAIN_260203211242579676_29)) AS HBLength
UNION ALL
SELECT @pMAIN_260203211242579676_30 AS Algorithum,
       HASHBYTES(@pMAIN_260203211242579676_31, @pMAIN_260203211242579676_32) AS TerritoryDescriptionHB,
       LEN(HASHBYTES(@pMAIN_260203211242579676_33, @pMAIN_260203211242579676_34)) AS HBLength;


            
        

Parameters (If used)

Query Results 1: