What is the alternative for number(2,0) of oracle in sqlserver?

Question

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 .

Answer 1

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:

Answer 2

Following are some alternatives in sql server

numeric(2,0)
decimal(2,0)

and as it haven't floating point you can take

int