CODEWITHSUNDEEP
sqlarrayscomparison
Nissim
Nissim

Reputation: 6553

Comparing arrays with sql

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.

Upvotes: 1

Views: 1593

Answers (1)

Ralf de Kleine
Ralf de Kleine

Reputation: 11734

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

Upvotes: 3

Related Questions