Introduction:
In this article I will explain what is the difference between bit, tinyint, smallint, int and bigint datatypes in SQL Server.
In this article I will explain what is the difference between bit, tinyint, smallint, int and bigint datatypes in SQL Server.
Description:
In previous post I
explained Differences between char, varchar and nvarchar in
SQL Server and many articles relating to SQL
Server. Now in this article I will explain what is the difference
between bit, tinyint, smallint, int and bigint datatypes in SQL
Server.
Bit DataType
This datatype represents a single bit that can be 0 or 1.
tinyint DataType
This datatype represents a single byte which is used to store values
from 0 to 255 (MinVal: 0, MaxVal: 255). Its storage size is 1 byte.
smallint DataType
This datatype represents a signed 16-bit integer which is used to store values from -2^15 (-32,768)
through 2^15 - 1 (32,767) and its storage size is 2 bytes.
int DataType
This datatype represents a signed 32-bit integer which is used to
store values from -2^31(-2,147,483,648) to 2 ^31-1(2,147,483,647). Its storage size
is 4 bytes.
Bigint DataType
This datatype represents a signed 64-bit integer which is used to
store values from -2^63
(-9223372036854775808) through 2^63-1 (9223372036854775807). Its storage size is
8 bytes.
|
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email. |
|||
Subscribe by RSS
Subscribe by Email
|
|||
|
|
|
3 comments :
thank you suresh,nice article
nice
when and where these datatyes to be used , i mean how we can differentiate the results of these datatypes