Let's say I insert a 64bit double floating point in the DECIMAL (17.5) field. Does the value contain rounding or truncation?
These are the rounds:
select cast(9.12345 as decimal(10,4))
Returns 9.1235
9.1235