Does SQL Server round or truncate?

Question

Say I'm inserting a 64 bit floating point double into a DECIMAL(17,5) field. Does the value get rounded or truncated?

Answer 1

Why don't you just try it out?

Answer 2

It rounds:

select cast(9.12345 as decimal(10,4))

Returns 9.1235