Sum of the size of "image" fields? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Sum of the size of "image" fields?

Author

Topic

vermorel
Starting Member

26 Posts

Posted - 2006-05-03 : 09:25:29

I have a have table containing an "image" field along a few other fields. I would like to retrieve the sum of the sizes a collection of "images", i.e. the pseudo-code below

SELECT SUM(SIZEOF(MyImage)) 
FROM MyTable
WHERE MyTable.SomeId = @SomeId

Does anyone knows how to do that?

Thanks in advance, Joannes

vermorel
Starting Member

26 Posts

Posted - 2006-05-03 : 09:41:57

Ok, it's not "SIZEOF", it's "DATALENGTH". Sorry for spamming.
Joannes

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources