sql varbinary string to varbinary

Question

How I can convert or insert '0x002D1ED54914534CAB1B2F2192A4620A01000000FB78B25328B7D36BA971BAE43E54F77C61ECDE8438B166C64D62406FECC2AFE4E788F36017B5F752' intoa varbinary column?

Possible duplicate of [Insert varbinary data into SQL Server database](http://stackoverflow.com/questions/25487445/insert-varbinary-data-into-sql-server-database) — Rick S, Dec 08 '15 at 18:44

score 1 · Accepted Answer · answered Dec 08 '15 at 18:44

1

INSERT INTO {your table} VALUES (0x002D1ED54914534CAB1B2F2192A4620A01000000FB78B25328B7D36BA971BAE43E54F77C61ECDE8438B166C64D62406FECC2AFE4E788F36017B5F752)

answered Dec 08 '15 at 18:44

BryanOfEarth

632
10
25

score -1 · Answer 2 · answered Dec 08 '15 at 18:44

-1

Maybe try casting it:

SELECT CAST('0x002D1ED54914534CAB1B2F2192A4620A01000000FB78B25328B7D36BA971BAE43E54F77C61ECDE8438B166C64D62406FECC2AFE4E788F36017B5F752' AS VARBINARY)

answered Dec 08 '15 at 18:44

Mark Kram

5,478
7
50
68

sql varbinary string to varbinary

2 Answers2