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_2606200315572563870 AS Algorithum,
HASHBYTES(@pMAIN_2606200315572563871, @pMAIN_2606200315572563872) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_2606200315572563873, @pMAIN_2606200315572563874)) AS HBLength
UNION ALL
SELECT @pMAIN_2606200315572563875 AS Algorithum,
HASHBYTES(@pMAIN_2606200315572563876, @pMAIN_2606200315572563877) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_2606200315572563878, @pMAIN_2606200315572563879)) AS HBLength
UNION ALL
SELECT @pMAIN_260620031557256387_10 AS Algorithum,
HASHBYTES(@pMAIN_260620031557256387_11, @pMAIN_260620031557256387_12) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260620031557256387_13, @pMAIN_260620031557256387_14)) AS HBLength
UNION ALL
SELECT @pMAIN_260620031557256387_15 AS Algorithum,
HASHBYTES(@pMAIN_260620031557256387_16, @pMAIN_260620031557256387_17) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260620031557256387_18, @pMAIN_260620031557256387_19)) AS HBLength
UNION ALL
SELECT @pMAIN_260620031557256387_20 AS Algorithum,
HASHBYTES(@pMAIN_260620031557256387_21, @pMAIN_260620031557256387_22) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260620031557256387_23, @pMAIN_260620031557256387_24)) AS HBLength
UNION ALL
SELECT @pMAIN_260620031557256387_25 AS Algorithum,
HASHBYTES(@pMAIN_260620031557256387_26, @pMAIN_260620031557256387_27) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260620031557256387_28, @pMAIN_260620031557256387_29)) AS HBLength
UNION ALL
SELECT @pMAIN_260620031557256387_30 AS Algorithum,
HASHBYTES(@pMAIN_260620031557256387_31, @pMAIN_260620031557256387_32) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260620031557256387_33, @pMAIN_260620031557256387_34)) AS HBLength;
Parameters (If used)
| Name |
Value |
| @pMAIN_2606200315572563870 |
MD2 |
| @pMAIN_2606200315572563871 |
MD2 |
| @pMAIN_2606200315572563872 |
abcdef |
| @pMAIN_2606200315572563873 |
MD2 |
| @pMAIN_2606200315572563874 |
abcdef |
| @pMAIN_2606200315572563875 |
MD4 |
| @pMAIN_2606200315572563876 |
MD4 |
| @pMAIN_2606200315572563877 |
abcdef |
| @pMAIN_2606200315572563878 |
MD4 |
| @pMAIN_2606200315572563879 |
abcdef |
| @pMAIN_260620031557256387_10 |
MD5 |
| @pMAIN_260620031557256387_11 |
MD5 |
| @pMAIN_260620031557256387_12 |
abcdef |
| @pMAIN_260620031557256387_13 |
MD5 |
| @pMAIN_260620031557256387_14 |
abcdef |
| @pMAIN_260620031557256387_15 |
SHA |
| @pMAIN_260620031557256387_16 |
SHA |
| @pMAIN_260620031557256387_17 |
abcdef |
| @pMAIN_260620031557256387_18 |
SHA |
| @pMAIN_260620031557256387_19 |
abcdef |
| @pMAIN_260620031557256387_20 |
SHA1 |
| @pMAIN_260620031557256387_21 |
SHA1 |
| @pMAIN_260620031557256387_22 |
abcdef |
| @pMAIN_260620031557256387_23 |
SHA1 |
| @pMAIN_260620031557256387_24 |
abcdef |
| @pMAIN_260620031557256387_25 |
SHA2_256 |
| @pMAIN_260620031557256387_26 |
SHA2_256 |
| @pMAIN_260620031557256387_27 |
abcdef |
| @pMAIN_260620031557256387_28 |
SHA2_256 |
| @pMAIN_260620031557256387_29 |
abcdef |
| @pMAIN_260620031557256387_30 |
SHA2_512 |
| @pMAIN_260620031557256387_31 |
SHA2_512 |
| @pMAIN_260620031557256387_32 |
abcdef |
| @pMAIN_260620031557256387_33 |
SHA2_512 |
| @pMAIN_260620031557256387_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
|