Sample Header Ad - 728x90

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