:::: MENU ::::

Signed and unsigned integer data types in SQL Server

  • Apr 13 / 2009
  • 1
Data Modeling and Database Design, Data Types, dbDigger

Signed and unsigned integer data types in SQL Server

SQL Server have following data types of integer family

  • bigint
  • int
  • smallint
  • tinyint
  • bit

All members in integer family of data types except tinyint may handle negative values. So whenever using tinyint make sure that always positive value will be inserted against tinyint data type. Tinyint has values in range of 0 to 255. If an out of range value is presented then Arithmetic overflow error for data type tinyint will be generated.

  • Hi Atif,

    Great blog. Was looking for info about unsigned integers in SQL.

    Gr
    Hennie
    BIFuture.blogspot.com

Consult us to explore the Databases. Contact us