Question about SQL Server

Printable View

Feb 25th, 2000, 06:58 AM
Gimpster

I have a question about the way SQL Server works and I didn't know where else to go to get an answer. I have a column in one of my tables. It's datatype is an integer and it is set to auto-increment. Since this column is set as an integer, it has a maximum value of 2,147,483,647 and since it is set to auto-increment, I was wondering if, when it reaches that value, it will start back over at 1, or if it will throw a tantrum and my whole database will be screwed? I'm hoping it will start back at 1, but that's what I need to know. Thank you, and sorry for the "non-VB related" question.
Feb 26th, 2000, 11:42 AM
JHausmann

One of my books says nothing the other says you're done when you insert the highest value possible...
Feb 27th, 2000, 01:26 AM
Clunietp

Do you really plan on having more than 2 billion records in a table, or are you just curious?

The decimal/numeric data type can be up to 10 ^ 38 if you're concerned you might hit the 2 billion number limit. This is the largest field an identity column can be, or you can use a GUID/Uniqueidentifier as well.....
Feb 27th, 2000, 11:17 PM

Arithmetic overflow

it will not start back from 1. you will not be able to insert further records as you will be getting arithmetic overflow error while converting int to identity

vinoo

Quote:

I have a question about the way SQL Server works and I didn't know where else to go to get an answer. I have a column in one of my tables. It's datatype is an integer and it is set to auto-increment. Since this column is set as an integer, it has a maximum value of 2,147,483,647 and since it is set to auto-increment, I was wondering if, when it reaches that value, it will start back over at 1, or if it will throw a tantrum and my whole database will be screwed? I'm hoping it will start back at 1, but that's what I need to know. Thank you, and sorry for the "non-VB related" question.