SQL Server currently supports 37 different datatypes. But Many people may not know that there are some datatypes in SQL Server which are considered as Special datatypes. They are listed below
bit hierarchyid sql_variant sysname table timestamp Alias data types
They are knwon as special datatypes as they don't fit into any other datatypes.
To know more informations about all datatypes, refer this post http://beyondrelational.com/blogs/madhivanan/archive/2010/11/08/list-of-datatypes-supported-in-sql-server.aspx
Tags: t-sql, sql_server, sqlserver, tsql, BRH, DataTypes,