May 4, 2017 at 9:49 pm
Comments posted to this topic are about the item Decimal Data Type
May 5, 2017 at 12:28 am
Interesting question, Robert
Had to read up on this, so learned something
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
May 5, 2017 at 12:49 am
Great question introduced me to some SQL 2012 functionality I've not come across before.
May 5, 2017 at 2:18 am
Very interesting question. Thanks for the link as well.
May 5, 2017 at 2:25 am
Much more interesting QOTD than at first glance.
May 5, 2017 at 6:22 am
Good question. I recently found myself researching that Precision, Scale and Length page to figure out why some division kept giving me extra zeros at the end of the number. And it was because of simple math: max(6, s1 + p2 + 1)
May 5, 2017 at 10:13 am
Nice question. Illustrates the pitfalls of the decimal numbers combination rules (which are a consequence of the silliness of the definition of the decimal type) with a simple piece of arithmetic which throws away 5 orders of magnitude of accuracy for no good reason at all.
The sooner we get hardware and software which supports the modern floating point standard instead of decades outdated nonsense (for both decimal and floating point) that forces us to choose one wrong type or another because the right type isn't available the better. But I don't see any sign of it happening, partly because almost everybody is wedded to one side or the other of the "lets to decimal/floating point because floating point/decimal is hopelessly wrong" wars and aren't even aware that the latest IEEE standard provides the best of both worlds and the inherent faults of neither. And partly because the hardware won'tbecome common until it's clear that the software will use it, and the software companies probably won't plan to use it until after both (a) the hardware has become common and (b) the ignoramuses on standards committees wake up and add a datatype that represents it to the SQL standard and lots of other langage standards.
Tom
May 8, 2017 at 9:20 am
Interesting question and interesting discussion. Thanks to both Robert and Tom!
May 16, 2017 at 1:31 am
Trick question,but got it.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
May 16, 2017 at 1:46 am
Like these sorts of questions the ones where you go I know this, then take a step back and do the reading due to that niggle of doubt that creeps in. Its the niggle of doubt that keeps us learning and on our toes.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply