SQL Tutorial: Misc Data Types

Data Type Description
sql_variant

Stores values of various SQL Server-supported data types, except text, ntext, and timestamp.

timestamp

Stores a database-wide unique number that gets updated every time a row gets updated

uniqueidentifier

Stores a globally unique identifier (GUID)

xml

Stores XML data

cursor

Reference to a cursor object

table

Stores a result set for later processing