Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Query to find the size of data in a column

Tags:

sql

sql-server-2008

I have a column called RawData of datatype Image 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

like image 264
Derin Avatar asked Dec 27 '22 21:12

Derin

1 Answers

SELECT * FROM tbl WHERE DATALENGTH(RawData) > 1048576
like image 118
Nik Avatar answered Jan 15 '23 10:01

Nik
Sign in to Comment

Related questions

SQL/Oracle Grouping Data by field by hours for a certain type on a given day
Select MySQL data with where clause in 2 tables
Selecting a row where, 1=a, 2=b OR 1=b, 2=a
Create a scalable database schema for storing golf scores
TABLOCKX versus SERIALIZABLE
Is it possible there is a faster way to perform this SELECT query?
Oracle11g numeric overflow in for loop
What's the database performance improvement from storing as numbers rather than text?
DB design when data is unknown about an entity?
Question about the merits of Pivot vs Case
What is the proper way to get the last entry for each foreign key of a history table?
passing parameters to a stored procedure in C#
MySQL Inner Join table based on column value
What ADO type is the Geography spatial type from SQL Server 2008?
MYSQL JOIN with unique result rows
Copy tables with different column name MySQL
ORA-01489: result of string concatenation is too long
Top 1 distinct rows from a table
Dynamically inserting multiple rows to a table
SQL Server: select distinct mon-yyyy format output sorty by descending order

Donate For Us

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