What is the size of a image field content in SQL Server?

Question

I have a table in SQL Server. This table has an image field and the application stores files in it.

Is there a way to read the size of the file in the image field using T-SQL?

Phil · Accepted Answer · 2023-04-11T09:58:53.527

104

SELECT DATALENGTH(imagecol) FROM  table

See MSDN

edited Apr 11 '23 at 09:58

answered Apr 04 '12 at 21:26

Phil

42,255
9
100
100

4

The result will be the *number of bytes*. – slartidan Feb 12 '16 at 10:40
11

In _megabytes_ it would be `SELECT DATALENGTH(imagecol) / 1048576.0 FROM table` – Aleksei Mialkin Mar 04 '16 at 17:04

score 13 · Answer 2 · answered Jun 20 '17 at 10:03

Different display styles:

SELECT DATALENGTH(imagecol) as imgBytes,
       DATALENGTH(imagecol) / 1024 as imgKbRounded,
       DATALENGTH(imagecol) / 1024.0 as imgKb,      
       DATALENGTH(imagecol) / 1024 / 1024 as imgMbRounded,
       DATALENGTH(imagecol) / 1024.0 / 1024.0 as imgMb
FROM   table

Example output:

imgBytes    imgKbRounded    imgKb       imgMbRounded    imgMb
68514       66              66.908203   0               0.065340041992

What is the size of a image field content in SQL Server?

2 Answers2

Linked