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