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

e0bqpujr 于 2023-04-19 发布在 SQL Server

关注(0)|答案(2)|浏览(134)

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?

sql-server

来源：https://stackoverflow.com/questions/10019438/what-is-the-size-of-a-image-field-content-in-sql-server

2条答案

按热度按时间

a6b3iqyw1#

SELECT DATALENGTH(imagecol) FROM  table

See MSDN

赞(0）回复(0）举报 2023-04-19

tgabmvqs2#

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

赞(0）回复(0）举报 2023-04-19

我来回答

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

2条答案

相关问题

热门标签

最新问答