Query to find data size in column

Question

I have a column with a RawDatadata type name Imagein my table. I need to find all rows that are larger than 1 MB.

It would be great if someone helped me with this question. I am using SQL Server 2008.

Thanks in advance

+3

Derin May 05 '11 at 6:35

1 answer

Nik · Accepted Answer · 2011-05-05T06:40:36+0000

SELECT * FROM tbl WHERE DATALENGTH(RawData) > 1048576