Standards and compliance

These are the ANSI SQL standards and compliance levels for Transact-SQL datatypes. See Reference Manual: Building Blocks for more information about standards and compliance.

Transact-SQL – ANSI SQL datatypes char, varchar, smallint, int, bigint, decimal, numeric, float, real, date, time, double precision

Transact-SQL extensions – User-defined datatypes binary, varbinary, bit, nchar, datetime, smalldatetime, bigdatetime, bigtime, tinyint, unsigned smallint, unsigned int, unsigned bigint, money, smallmoney, text, unitext, image, nvarchar, unichar, univarchar, sysname, longsysname, timestamp