Tuesday, July 30, 2013

Arithmetic overflow error converting numeric to data type numeric - SQL 2008

Dont find an issue with this value, any other value could be an issue.



declare @test numeric(12,2)
set @test=999999996.00
select @test
set @test=cast(999999996.00 as numeric(12,2))
select @test





Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


No comments:

Post a Comment