Updating a table which contains an Image datatype column
3
votes
1
answer
2085
views
I have a table which contains a few columns, one of which is an image datatype, this is used to store BLOB data, which could be anything from a jpg to a large PDF.
I have a requirement to update one of the other columns in the table, however the query is taking a ludicrously long time to complete - that's if it does complete at all.
The table is the following format:
ID (int), HexData (image), FileName(nvar), Filetype(nvar), folder(nvar), user(int)
The query used is simply -
update [database].[dbo].[myTable]
set user = 5
where id = 2
This is a test table on a test database, not the live system. There are only 5 rows, no indexes (including clustered), and no other tables in the database.
Asked by SeanR
(257 rep)
Dec 14, 2015, 10:09 AM
Last activity: Feb 11, 2025, 07:19 AM
Last activity: Feb 11, 2025, 07:19 AM