posted 1/26/2012 by ogonzalez - Views: [283]
Whether you consider these to be the same or list that they are technically different there is still a valid discussion of why you should use one verses the other. It?s a trick question! The precision and scale will produce the same results no matter what the data entered.
I entered data with the same precision and scale but changed the data on each row. Take a look at the insert statement.
I swamped the insert statement and played with all sorts of numbers. Even if I had 8 digits to the right of the decimal the data stored in the row is based on the precision.
Another blog said that decimal had to be exact and the numeric had to be at least. Do if decimal is declared (18, 2) and numeric is declared (18,2) then decimal has to have 2 to the right and numeric has to have at least 2 to the right. What is the difference? They are the same. So which one should you use? Which ever on you like. Post commentary and questions as replies to this blog. #in