List of datatypes in SQL Server

We are using very few data type in SQL Server like INT, varchar,datetime etc But there are currently 37 datatype supported by SQL Server 2008

See the below scripts

  • exec sp_datatype_info
  • select * from sys.types
  • exec sp_datatype_info_90
  • exec sp_datatype_info_100