当我运行SQL查询时,我得到这样的东西:
Disallowed implicit conversion from data type varchar to data type
varbinary…. Use the CONVERT function to run this query. (severity
16)`
我想插入的数据看起来像
'00001200000000000010000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF...FFF'
如何做这个查询?
查询看起来像:
UPDATE <table> SET VARBINARY_DATA = '00001200000000000010000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFF....' WHERE ID = 12