SQL Kiwi (1/4/2012)
There are many quirks to SQL Server
A bad thing tm!
SQL Kiwi (1/4/2012)
The point of this QotD is very much to emphasise that using excessive precision or scale can have unintended consequences.
And has done so in spades!
SQL Kiwi (1/4/2012)
Very few real-world uses would require anything like the DECIMAL(38,20) types specified in the question.
I beg to differ - Financial Markets where big $ times %ages times year fractions - happens all the time. "Consequences" like this one would be real pain - so thanks again for raising it - fortunately it doesn't happen in the platforms I commonly use!
BTW - even 11.9.2 behaves per my prior post!