Mapping .Net decimal with large number of fraction to SQL Server
If I have a decimal like 32.593170731707329023999999999 - what SQL Datatype, and precision and scale should I use?
My integer parts are pretty small (1开发者_Python百科-10000) and fraction part big.
Have tried decimal with different variations of precision and scale, but get an overflow exception in .Net.
You can try this
DECLARE @D DECIMAL(38, 33)
SELECT @D = 10000.593170731707329023999999999
SELECT @D
精彩评论