Declare @Binary varbinary(max);
set @Binary =0xFFD8FFE000104A46494600010101006000600000FFDB0043000705050605040706050.........
update [dbo].[TB_DigitalAccountOCR]
set IMG_BINARY =@Binary
where SESSION_ID='84ef7713-77ff-4f59-b45f-c2268ed7c621' and IMG_TYPE='IDCard0'
然後去查SELECT
[IMG_BINARY]
FROM [Skb_CloudDesk_UAT].[dbo].[TB_DigitalAccountOCR]
where SESSION_ID='84ef7713-77ff-4f59-b45f-c2268ed7c621' and IMG_TYPE='IDCard0'
發現值與@Binary 不一樣會漏字 查了很久不知道怎麼完整塞值QQ 我只有一串binary字串
已邀請的邦友 {{ invite_list.length }}/5
不知道你的表格的欄位類型跟長度為何..
欄位：IMG_BINARY
iThome鐵人賽
看影片追技術