Fix The Blue Screen Of Death On Your Pc

How to initialize set a binary variable in T SQL

I have a stored procedure that expects a binary input parameter. I wanted to test it using a T-SQL statement in the query window. But i was wondering how to declare and set a binary variable using T-SQL.

How-i-fixed-it:
Just define the variable and set the bytes individually.

Example for a 6-Byte-Array:
declare @roi varbinary(6);

set @roi = 0x100010001000

exec sp_GetData_ROI 3001, @roi

for details click below