在SQL Server中存储MD5哈希

CREATE TABLE ExampleTable (
    ID INT PRIMARY KEY,
    Data NVARCHAR(MAX),
    HashValue VARBINARY(32)
);

INSERT INTO ExampleTable (ID, Data) VALUES (1, 'This is a sample text.');

UPDATE ExampleTable
SET HashValue = HASHBYTES('MD5', Data)
WHERE ID = 1;

SELECT ID, Data, HashValue
FROM ExampleTable
WHERE ID = 1;

ID | Data                    | HashValue
----------------------------------------------------------------------
1  | This is a sample text.  | 0x1E38510C472F8624F2F8FDE12F9A653B5