This is an article in the series that we talking about translate SQL query among different databases.
This article focus on the translation of number datatype between oracle and SQL Server database.
The main difference of number datatype between oracle and SQL Server is float. ANSI SQL requires float precision to be specified in terms of binary bits. But the number of binary bits specified in float definition of Oracle and SQL Server doesn’t have the same meanings.
In SQL Server, syntax of float datatype is float[(n)], Where n is the number of bits...