Comparing arrays with sql

Question

I want to perform a 'SELECT' statement with a byte array (binary) parameter as a condition. I tried to google it, but didn't find anything useful.

In general, I keep information of files in the database. one of the properties is the file's hash (binary).

I want to give a hash to the SELECT statement, and get all rows with the same hash value.

Answer 1

DECLARE @PARA BINARY
SET @PARA = 0X000
SELECT @PARA
SELECT 
    *
FROM
    [Table]
WHERE
    PARA = @PARA