Decimal registration in numeric type of SQL server results in 0

The c# program used double variables and registered them in the column of type numeric(12,3) of SQL server, and it turned out to be 0.

The actual formula is 99999999.999-9999999.998
The answer is 0.001.

When I registered this answer with Oracle number (12,3), it was 0.001, but when I registered with SQL server, it was zero.

Is the parameter mapping method incorrect when registering?

c# sql-server

2022-09-29 22:16

2 Answers

SQL Server numeric type is numeric(18,0) if no precision is specified.Since scale=0, we can only handle integers.This is probably the reason.

Although the questionnaire does not mention how C# passed the data to SQL Server, it is presumed that accuracy was not specified when passing it.For example, C#'s decimal (.NET's System.decimal) was automatically converted without any accuracy hints.

2022-09-29 22:16

The reason seems to be that the calculation result for double type was less than 0.001.
Oracle will register the results at 0.001, but SQL server will register truncated to 0.000.

During the operation, I was able to solve this problem by calculating once in the decimal type and registering the results.

2022-09-29 22:16

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656