SQL Server datatypes are not always what they seem to be. Martin Schmidt recently had an interesting blog post (in danish) regarding implicit decimal conversion that sparked my interest. Let me sketch ...

This is because the create table function produced by csvsql neglected to specify the precision and scale of the decimals: 42.4242424242 changes to 42 because the type of this row is DECIMAL (10,0).

When you define a column in MS SQL server as either decimal or numeric (these are both options but do the same thing) you need to define a fixed precision and scale value for that column.