Arithmetic overflow

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Arithmetic overflow

Arithmetic overflow

Rate Topic

Display Mode

Topic Options

Author

Message

baumgaertner

Posted Wednesday, April 08, 2009 1:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, June 12, 2009 8:16 AM
Points: 38, Visits: 129

Hello,

when I try the following sql I get an error:

select sum(datalength(memTest))
from tblTest

Arithmetic overflow error converting expression to data type int

Has anyone an idea?

Thanks.

Post #692812

BrainDonor

Posted Wednesday, April 08, 2009 1:58 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:05 AM
Points: 1,400, Visits: 6,896

Hi,

According to BOL, DataLength returns either an int or bigint depending upon the type of the field it is examining. So what is the definition of 'memTest' and how many rows are there?
It could be that it is going to return an int, but the accumulated value is too large for such a field.

BrainDonor

BrainDonor
Linkedin

Post #692827

Kruti Kansara

Posted Wednesday, April 08, 2009 2:26 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 09, 2011 2:49 AM
Points: 536, Visits: 412

Try this,

select sum(Convert(bigint,datalength(memTest),0))
from tblTest

"Don't limit your challenges, challenge your limits"

Post #692834

baumgaertner

Posted Wednesday, April 08, 2009 3:46 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, June 12, 2009 8:16 AM
Points: 38, Visits: 129

Thanks kruti, it works.

Post #692890

« Prev Topic | Next Topic »

Permissions