Menu
in my oracle tables some columns are having number(2,0), number(5,0) datatype, so I want to know what are the alternative datatypes in sql server for that .
666
INSTR is another option but you cannot have an index which suits this comparison. Save this answer.
NUMERIC determines the exact precision and scale. DECIMAL specifies only the exact scale; the precision is equal or greater than what is specified by the coder. DECIMAL columns can have a larger-than-specified precision if this is more convenient or efficient for the database system.
The T-SQL equivalent is DECIMAL or NUMERIC.
Examples: NUMERIC(2, 0) and DECIMAL(5, 0)
They are functionally equivalent.
Here's a breakdown of the exact numeric types:
90
Following are some alternatives in sql server
numeric(2,0)
decimal(2,0)
and as it haven't floating point you can take
int
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
