Hello Frdz,
I have doubt regarding the datatypes fields used in SQL SERVER 2005.
The value for bigint Int64 is 18
The value of int Int32 is 9/10
Now,if in int i write : 1234567890 (accepted)
This gives error : 9874565656 (not accepted........why is it so ? )
Why is it so ??
I want to know the perfect size of all the datatypes used in SQLSERVER 2005.
There are also smallint,tinyint....
What's the main difference with all of them ??
Can anyone provide me the nice links which can explain me what m i asking in this post...
Please help me...I want to know all the datatypes used differences...
you cannot store 9874565656 in an int as it exceeds the max value for an int which is: 2,147,483,647
http://msdn2.microsoft.com/en-us/library/ms187745(SQL.90).aspx
|||
thanxs...i think it's helpful link..
I want to also know that in SQL SERVER 2005 can we assign or fix manually the values upto the limit...like,
Id1 int - 4
Id2 bigint - 10
like in varchar we can do
Name Varchar(20) if we take varchar(50) as datatype...
Hope u understand what i ask...this questions are not solved in my mind...
Please help me...
Thanxs again....
|||varchar is a variable length datatype and you are allowed to set its length
you cannot do that with the integer datatypes.
|||
If you really intend to limit the value <= 4 digits ( = 9999) you can create a constraing on the column to make sure the value <= 9999.
|||You can also create your own datatype that is based on an integer value type that can store all your possible values and has a constraint.
This may help:
http://weblogs.asp.net/alex_papadimoulis/archive/2005/10/07/426930.aspx
More complex datatype needs can be done via a CLR UDT, but I'm not sure how well they perform. Like:
http://www.devx.com/dotnet/Article/22644
|||thanxs all of...
I think it's better to make a constraint......
Nice answers to clear my doubt...
