Can anyone give me a quick way to update an image in SQL Server? I have a client that has released a new logo and I need to update the image on file. Never done this with the actual image in the DB rather than a pointer to the image file. Thanks, All!

Cheers~

Monty D. Grimmett

INSERT the new ímage into a temp table.
Then update as normal.

Thanks Peso! I used the following code in case someone else wants to see!

Cheers~

UPDATE SCHEMA.TABLE
SET FLD = (SELECT * FROM OPENROWSET(BULK 'IMG_FILE', SINGLE_BLOB)AS x)
WHERE Criteria_To_Update_Target_Row;
GO

Monty D. Grimmett