decimal conversion error (arithmatic overflow) error

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

hi all,

i am getting

C#

Arithmetic overflow error converting varchar to data type numeric.

this error.
the code script is below

C#

Declare @Amount Decimal(18,4)

Declare @strSql VARCHAR(MAX)

SET @strSql =''

SET @strSql = 'UPDATE TABLE1 SET col1='+@Amount+' where id=1'
print @strSql 

--EXEC(@strSql)

i am using exec because the where condition is dynamic.the table column is also has the same type.

Please help me out.

Thanks

Posted 24-Feb-14 5:44am

S.P.Tiwari

Add a Solution

Comments

phil.o 24-Feb-14 11:47am

What is the current value of @Amount when your procedure throws its error?

S.P.Tiwari 24-Feb-14 12:13pm

well i was passing 0.25 .

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2014-02-24T05:49:00

Solution 1

Two things you need to fix:
1) Give @Amount a value - at present it is null, so it won;t work too well.
2) Convert @Amount to a VARCHAR

SQL

Declare @Amount Decimal(18,4)
Declare @strSql VARCHAR(MAX)
SET @strSql =''
SET @Amount=0.0
SET @strSql = 'UPDATE TABLE1 SET col1='+CONVERT(VARCHAR, @Amount)+' where id=1'
print @strSql

Posted 24-Feb-14 5:49am

OriginalGriff

Comments

S.P.Tiwari 24-Feb-14 12:11pm

thanks griff. i will check this. well i was passing 0.25 .

S.P.Tiwari 25-Feb-14 2:33am

Thanks Griff. its working fine. thanks again

OriginalGriff 25-Feb-14 3:09am

You're welcome!

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Accepted Answer · 2014-02-24T05:56:00

Solution 2

OriginalGriff is correct.

To know more about this issue, refer - Msg 8115 - Arithmetic overflow error converting numeric to data type varchar.[^] and SQL SERVER – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type[^].

Posted 24-Feb-14 5:56am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

S.P.Tiwari 25-Feb-14 2:33am

THANKS TADIT. ITS working fine

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 25-Feb-14 2:47am

Most welcome buddy. :)

decimal conversion error (arithmatic overflow) error

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

decimal conversion error (arithmatic overflow) error

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us