MSSQL Server Data Types: [* – New data type for this version]

Exact Numeric: int, smallint, tinyint, bit;
Approximate Numeric: decimal, numeric, money, smallmoney, floats, real
Date and Time: datetime, smalldatetime, datetime2*, datetimeoffset*, date*, time*
Character Strings: char, varchar, text;
Unicode Character Strings: nchar, nvarchar, ntext
Binary Strings: binary, varbinary, image
Other Data Types: Cursor, Timestamp, sql_variant, Uniqueidentifier, table, Xml, HierarchyID*, Spatial* [Geography and Geometry]

Leave a Reply

Your email address will not be published. Required fields are marked *