SQL Server & C# -如何检查我正在上传的varbinary(max)文件是否已经存在于表中？

CREATE PROCEDURE CheckFileExists
    @fileData VARBINARY(MAX)
AS
BEGIN
    IF EXISTS (SELECT 1 FROM YourTable WHERE FileData = @fileData)
        SELECT 'File already exists' AS Result
    ELSE
        SELECT 'File does not exist' AS Result
END

DECLARE @fileData VARBINARY(MAX)
SET @fileData = (SELECT BulkColumn FROM OPENROWSET(BULK 'C:\Path\To\Your\File.ext', SINGLE_BLOB) AS x)

EXEC CheckFileExists @fileData