Hi Friends ,
In this Thread we will Discuss about Sql data type Ranges ,
Exact numerics

bigint -9,223,372,036,854,775,808 To 9,223,372,036,854,775,807
int -2,147,483,648 To 2,147,483,647
smallint -32,768 To 32,767
tinyint 0 To 255
bit 0(False) To 1(True)
decimal -10^38 +1 To 10^38 –1
numeric -10^38 +1 To 10^38 –1
money -922,337,203,685,477.5808 To+922,337,203,685,477.5807
smallmoney -214,748.3648 To+214,748.3647

float -1.79E + 308 To 1.79E + 308
real -3.40E + 38 To 3.40E + 38

datetime (3.33 milliseconds accuracy) Jan 1, 1753 To Dec 31, 9999
smalldatetime (1 minute accuracy) Jan 1, 1900 To Jun 6, 2079

char Fixed-length non-Unicode character data with a maximum length of 8,000 characters.
varchar Variable-length non-Unicode data with a maximum of 8,000 characters.
varchar(max) Variable-length non-Unicode data with a maximum length of 231 characters (SQL Server 2005 only).
text Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters.

nchar Fixed-length Unicode data with a maximum length of 4,000 characters.
nvarchar Variable-length Unicode data with a maximum length of 4,000 characters.
nvarchar(max) Variable-length Unicode data with a maximum length of 230 characters (SQL Server 2005 only).
ntext Variable-length Unicode data with a maximum length of 1,073,741,823 characters.

binary Fixed-length binary data with a maximum length of 8,000 bytes.
varbinary Variable-length binary data with a maximum length of 8,000 bytes.
varbinary(max) Variable-length binary data with a maximum length of 231 bytes (SQL Server 2005 only).
image Variable-length binary data with a maximum length of 2,147,483,647 bytes.

sql_variant Stores values of various SQL Server-supported data types, except text, ntext, and timestamp.
timestamp Stores a database-wide unique number that gets updated every time a row gets updated.
uniqueidentifier Stores a globally unique identifier (GUID).
xml Stores XML data. You can store xml instances in a column or a variable (SQL Server 2005 only).
cursor A reference to a cursor.
table Stores a result set for later processing

Thanks for all your post, I have the same problem and now it has been sorted!

__________________
brochure printingbrochures printingPlastikkartenplastic business cardplastic business cards