ANSI SQL – Compliance level: Transact-SQL provides the smallint, int, numeric, decimal, float, double precision, real, char, varchar, date and time ANSI SQL datatypes. The tinyint, binary, varbinary, image, bit, datetime, smalldatetime, money, smallmoney, nchar, nvarchar,unichar, univarchar, sysname, text, timestamp, and user-defined datatypes are Transact-SQL extensions.