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 2012 Forums
 Transact-SQL (2012)
 Big Decimal Type Error

Author  Topic 

samir.first
Starting Member

34 Posts

Posted - 2014-06-22 : 04:55:00
I am using decimal data type with large precision and scale decimal(38, 20)
And it runs fine when i use it in the Query Editor in SQL Management studio.
But when i use it in the Dot Net it gives "Conversion Over Flow" Exception.

Please Help Me For Choose Best Type

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-06-22 : 17:28:32
Data type sounds fine in SQL Server. What data type are you using in your application code? http://msdn.microsoft.com/en-us/library/cc716729(v=vs.110).aspx

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -