how to update the varbinary value with null in an image field in sql server 2008

Question

I want to update the varbinary value(oXFFDFFEEEFFFF....) stored in an image field of sql server to null

And what is stopping you? What is the problem you are seeing with this? — Oded
– Oded, Commented Jan 3, 2011 at 15:30
i am getting an exception called 'The data types image and varbinary(max) are incompatible in the equal to operator' — user377855
– user377855, Commented Jan 3, 2011 at 15:36

Phil Hunt · Accepted Answer · 2011-01-03 15:32:04Z

1

UPDATE TableName SET ImageColumn = NULL WHERE Id = @Id

answered Jan 3, 2011 at 15:32

Phil Hunt

8,5711 gold badge33 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user377855 Over a year ago

Than u for reply, but i have already tried and got above exception

Phil Hunt Over a year ago

@user377855: Please update your post and give more information. Are you getting this error from SQL Server Management Studio, or is it in your application? Please post your code as well.

user377855 Over a year ago

i am getting this exception in sqlserver mgmt studio,my query is:update organisation set logo= null where logo=0xFFD8FFE00010.......

user377855 Over a year ago

i am getting this exception in sqlserver mgmt studio,my query is:update organisation set logo= null where logo=0xFFD8FFE00010....... here organisation is tablename, logo is column of type image and can i replace that value with null or with any other binary value

Yousi Over a year ago

i think your problem is with your "where" condition. try to set it to the ID of the record instead of the logo value

Collectives™ on Stack Overflow

how to update the varbinary value with null in an image field in sql server 2008

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related