Database Options and Numeric Roundabort

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

sql-server-helper Newbie Points: 1 More actions · Answer 1

Nice tricky question! To make it a little bit trickier, you can also do something like this:

DECLARE @a NUMERIC(5,3) = 1.285
DECLARE @b NUMERIC(5,3) = 1.465
DECLARE @c NUMERIC(5,1)

SELECT @c = @a + @b
SELECT @c