I have a column called <code>RawData</code> of datatype <code>Image</code> in my table. I need to find all rows where the size of that column is more than 1 MB. It would be great if someone could help me with the query for this. I use SQL Server 2008. Thanks in advance

<pre class="prettyprint"><code>SELECT * FROM tbl WHERE DATALENGTH(RawData) > 1048576 </code></pre>

Query to find the size of data in a column

SELECT * FROM tbl WHERE DATALENGTH(RawData) > 1048576

118

answered Jan 15 '23 10:01

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!