Sql Auto Converts Decimal To Numeric When Select & Insert

I have SQL Server 2008 R2 and linked SQL Server 2012. When I do the following SELECT * INTO dbo.Local_table FROM dbo.Linked_table all decimal columns automatically get converted i

Solution 1:

This is automatic conversion that occurs with most SQL Servers. You'll find this happening with at least, but not limited to, server year versions 2000-2014. I don't know of a way to get rid of this restriction because it's a built in server feature which restricts arithmetic equations via query statements.

Here is another SO question/answer which might help you: T-SQL Decimal Division Accuracy

Here is some MSDN for clarification: https://msdn.microsoft.com/en-us/library/ms187746.aspx