Home Forums Article Discussions Article Discussions by Author Discuss content posted by mark.stockwell Fun with Scale and Precision RE: Fun with Scale and Precision

  • December 4, 2009 at 8:06 am

    #1087760

    Steve Eckhart (12/4/2009)

    select cast(1.67574 as decimal(38,10)) = 1.675400000 which has precision 6 and scale 10, right?

    and

    select cast(10000 as decimal(38,10)) = 10000.0000000000 which has precision 1 and scale 10, right?

    wrong, and wrong. Because you're explicitly casting to decimal(38,10), both of your results have precision of 38 and scale of 10 even though they don't apparently require it. SQL server will not narrow the precision and scale of an explicitly cast decimal result.