Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

Datatype equivalents from PLSQL to T-SQL

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