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_2602032247299134610 AS Algorithum,
HASHBYTES(@pMAIN_2602032247299134611, @pMAIN_2602032247299134612) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_2602032247299134613, @pMAIN_2602032247299134614)) AS HBLength
UNION ALL
SELECT @pMAIN_2602032247299134615 AS Algorithum,
HASHBYTES(@pMAIN_2602032247299134616, @pMAIN_2602032247299134617) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_2602032247299134618, @pMAIN_2602032247299134619)) AS HBLength
UNION ALL
SELECT @pMAIN_260203224729913461_10 AS Algorithum,
HASHBYTES(@pMAIN_260203224729913461_11, @pMAIN_260203224729913461_12) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260203224729913461_13, @pMAIN_260203224729913461_14)) AS HBLength
UNION ALL
SELECT @pMAIN_260203224729913461_15 AS Algorithum,
HASHBYTES(@pMAIN_260203224729913461_16, @pMAIN_260203224729913461_17) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260203224729913461_18, @pMAIN_260203224729913461_19)) AS HBLength
UNION ALL
SELECT @pMAIN_260203224729913461_20 AS Algorithum,
HASHBYTES(@pMAIN_260203224729913461_21, @pMAIN_260203224729913461_22) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260203224729913461_23, @pMAIN_260203224729913461_24)) AS HBLength
UNION ALL
SELECT @pMAIN_260203224729913461_25 AS Algorithum,
HASHBYTES(@pMAIN_260203224729913461_26, @pMAIN_260203224729913461_27) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260203224729913461_28, @pMAIN_260203224729913461_29)) AS HBLength
UNION ALL
SELECT @pMAIN_260203224729913461_30 AS Algorithum,
HASHBYTES(@pMAIN_260203224729913461_31, @pMAIN_260203224729913461_32) AS TerritoryDescriptionHB,
LEN(HASHBYTES(@pMAIN_260203224729913461_33, @pMAIN_260203224729913461_34)) AS HBLength;
Parameters (If used)
| Name |
Value |
| @pMAIN_2602032247299134610 |
MD2 |
| @pMAIN_2602032247299134611 |
MD2 |
| @pMAIN_2602032247299134612 |
abcdef |
| @pMAIN_2602032247299134613 |
MD2 |
| @pMAIN_2602032247299134614 |
abcdef |
| @pMAIN_2602032247299134615 |
MD4 |
| @pMAIN_2602032247299134616 |
MD4 |
| @pMAIN_2602032247299134617 |
abcdef |
| @pMAIN_2602032247299134618 |
MD4 |
| @pMAIN_2602032247299134619 |
abcdef |
| @pMAIN_260203224729913461_10 |
MD5 |
| @pMAIN_260203224729913461_11 |
MD5 |
| @pMAIN_260203224729913461_12 |
abcdef |
| @pMAIN_260203224729913461_13 |
MD5 |
| @pMAIN_260203224729913461_14 |
abcdef |
| @pMAIN_260203224729913461_15 |
SHA |
| @pMAIN_260203224729913461_16 |
SHA |
| @pMAIN_260203224729913461_17 |
abcdef |
| @pMAIN_260203224729913461_18 |
SHA |
| @pMAIN_260203224729913461_19 |
abcdef |
| @pMAIN_260203224729913461_20 |
SHA1 |
| @pMAIN_260203224729913461_21 |
SHA1 |
| @pMAIN_260203224729913461_22 |
abcdef |
| @pMAIN_260203224729913461_23 |
SHA1 |
| @pMAIN_260203224729913461_24 |
abcdef |
| @pMAIN_260203224729913461_25 |
SHA2_256 |
| @pMAIN_260203224729913461_26 |
SHA2_256 |
| @pMAIN_260203224729913461_27 |
abcdef |
| @pMAIN_260203224729913461_28 |
SHA2_256 |
| @pMAIN_260203224729913461_29 |
abcdef |
| @pMAIN_260203224729913461_30 |
SHA2_512 |
| @pMAIN_260203224729913461_31 |
SHA2_512 |
| @pMAIN_260203224729913461_32 |
abcdef |
| @pMAIN_260203224729913461_33 |
SHA2_512 |
| @pMAIN_260203224729913461_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
|