Am using Excel to upload the data into SQL Server. A column contains some decimal values. And while use to upload in the DB, Values precision scale is taken in default with some values.
Ex: Excel column : V1 = 2.36031
My DB column : V1 with data type as NUMERIC(27,15)
While fetching the Value from Excel into tempTable am getting the same value. On doing the CAST value it changes.
CAST(V1 as NUMERIC(27,15))
V1 value used to inserted in DB as 2.360309999999980
But my actual value to be 2.360310000000000
Please help to fix this issue.