Chapter 1: System and User-Defined Datatypes

Standards and compliance

Table 1-5 lists the ANSI SQL standards and compliance levels for Transact-SQL datatypes.

**Table 1-5: ANSI SQL standards and compliance levels for Transact-SQL datatypes**
Transact-SQL – ANSI SQL datatypes	Transact-SQL extensions – User-defined datatypes
char varchar smallint int bigint decimal numeric float real date time double precision	binary varbinary bit nchar datetime smalldatetime tinyint unsigned smallint unsigned int unsigned bigint money smallmoney text unitext image nvarchar unichar univarchar sysname longsysname timestamp