SQL Server - how to update a IMAGE from one TABLE to another
I have a IMAGE field that contains photos - I'm trying to update the image in another table with the following SQL
update repi set photo = dt.photo
from [crm].dbo.repinfo as dt
where repinfo.repno = '54K'
The image never fully updates and the IMAGE field shows just '0x'
What I'm I missing ? The source field has 0xFFD8FFE000104A46494600010201006000600000FFE1118A45786966000049492A000800000007001201030001000000010000001A01050001000000620000001B010500010000006A000000280103000100000002000000310102001D0000007200000032010200140000008F0000006987040001000000A4000000D00000...