Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 autonumber and int

Author  Topic 

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-20 : 22:33:41
i want to ask, how much maxlenght for autoincrement and integer..?

This information will help me..

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-10-20 : 22:35:59
it depends on the data type. For integer

quote:

int

Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).


http://msdn.microsoft.com/en-us/library/aa258271%28v=sql.80%29.aspx



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Risqi Aris
Starting Member

13 Posts

Posted - 2011-10-20 : 22:51:56
Is there a more detailed explanation?
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-10-20 : 23:29:32
there is an article on identity column by nigel here
http://www.simple-talk.com/sql/t-sql-programming/identity-columns/


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -