Comments

One response to “SQL Server Table Column Types”

1. 

   March 31, 2013

   SamRaj

   bigint Integer value (-9,223,372,036,854,775,808 – 9,223,372,036,854,775,807) 2^63
   int smaller Integer value (-2,147,483,648) – (2,147,483,647) 2^31
   smallint smaller Integer value (-32,768) – (32,767) 2^15
   tinyint smaller Integer values 0 – 255 2^8
   bit Integer data value (either 1 or 0 value) 1 or 0
   decimal Decimal values from -10^38 – 10^38 10^38
   numeric Decimal values from -10^38 – 10^38 10^38
   money Money values (-922,337,203,685,477.5808) – (922,337,203,685,477.5807) 2^63
   smallmoney Smaller Money Values (-214,748.3648) – (214,748.3647) 2^31
   datetime Date value (January 1, 1753) – (December 31, 9999)
   smalldatetime Smaller Date Value (January 1, 1900) – (June 6, 2079)
   timestamp Unique Number Value (updates when row is updated)
   char Character String Value (max 8,000 characters)
   varchar Character String Value maximum of 8,000 characters, unless otherwise noted)
   nchar Character String Value (max 4,000 characters)
   nvarchar Character String Value (max 4,000 characters)
   text Character String Value (max 2,147,483,647 characters) 2^31
   ntext Character String Value (max 1,073,741,823 characters) 2^30
   binary Binary Value (max 8,000 bytes)
   varbinary Binary Value (max 8,000 bytes)
   image Binary Value (max 2,147,483,647 bytes) 2^31
   uniqueidentifier Global Unique ID (GUID)

   Reply