Datatype equivalents from PL/SQL to T-SQL. : Data type « Data Types « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Data Types
3. Data type

PL/SQL Datatype                             T-SQL Datatype
NUMBER or DECIMAL                           DECIMAL or NUMERIC
FLOAT                                       FLOAT
REAL                                        REAL
NUMBER                                      MONEY, SMALLMONEY
LONG                                        DECIMAL or NUMERIC
INTEGER, BINARY_ INTEGER, PLS_ INTEGER      INTEGER
SMALLINT                                    SMALLINT
NUMBER or DECIMAL                           TINYINT
DOUBLE PRECISION                            DOUBLE PRECISION
NATURAL                                     DECIMAL or NUMERIC
NATURALN                                    DECIMAL or NUMERIC
POSITIVE                                    DECIMAL or NUMERIC
POSITIVEN                                   DECIMAL or NUMERIC
CHAR, CHARACTER                             CHAR, CHARACTER
VARCHAR, STRING                             VARCHAR
VARCHAR2                                    VARCHAR
RAW, LONG RAW                               TEXT, IMAGE
DATE                                        DATETIME, SMALLDATETIME
BOOLEAN                                     BIT
ROWID                                       TIMESTAMP