How to update the varbinary value with null in an image field in SQL Server 2008?
I have uploaded an image and stored into 开发者_开发知识库image field in database, that image is stored as 0xFFD8FFE. When I am trying to update the above with null as getting an exception called:
The datatypes image and varbinary(max) are incompatible in the equal to operator
I want to change the above value to null.
Just set it to null with an update statement:
UPDATE dbo.MyTable
SET MyFieldName = NULL
WHERE MyPrimaryKey = 12345
update organisation set logo= null where logo like 0xFFD8FFE00010
精彩评论