I want to update a row that is set with VARBINARY data type.
Declare @context VARBINARY(MAX) = 0x224456EFECV....EFT41
UPDATE SOMETABLE
SET COLUMN = @contex
where ID = 1
I have this query however, every I update the data, it adds 0 value after the prefix 0x.
after running the query,
COLUMN = 0x0224456EFECV….EFT4
BLOB import is not an option because database im trying to update is on cloud and im only replicating the data from the local.