Forum Discussion
FrancoisHuard
8 years agoAdvocate II
Decimal Values Precision
How can a change the precision of a decimal value Let says I have the following table CREATE TABLE dbo.Test (Column1 NUMERIC(32,12)) INSERT INTO dbo.Test VALUES(12.211112312131),(13.5555787...
ImkeF
8 years agoCommunity Champion
Now I see what you mean. Oddly enough, when that table is loaded to the datamodel, the missing decimals show up again. So it might just be a display issue in the query editor.
Greg_Deckler
8 years agoCommunity Champion
Ah, that's interesting. I wonder if someone from Microsoft can confirm that it is simply a display issue. I wonder if there is some calculation that could be performed to prove out whether or not it is maintaing the precision behind the scenes?