SQL Server Data Types

Here are the SQL server data types for quick reference,

1. Exact numerics – (bigint, bit, decimal, int, money, numeric, smallint)
2. Approximate numerics (float, real)
3. Date and time (date, datetime2, datetime, datetimeoffset, time)
4. Character strings (char, varchar, text)
5. Unicode character strings (nchar, ntext, nvarchar)
6. Binary strings (binary, varbinary, image)
7. Other data types (cursor, timestamp, uniqueidentifier, table)
8. Large valued data types (varchar(max), nvarchar(max))
9. Large object data types (text, ntext, image, xml)