Start records from Specific Number

[Gandalf_TheWhite]

Hi all, I want to start to enter my records from specific number. let's say I would like to start entry in database table from 1000 instead of 1. means right now my records are entered in database from 1. Instead of 1 I would like it to start from 1001. Is it possible? if yes then how?

Believe Yourself™

[Abhijit Jana]

Try This :

DBCC CHECKIDENT (tableName, RESEED, 1000)

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

[Lost User]

Make your question as clear as possible, so others can understand it properly. What you are referring to is probably start an identity column in a table. When creating the column, you can specify the seed and the increment.

CREATE TABLE Tab1
(
Col1 int IDENTITY (1000, 1)
)

If you want to change the seed of an existing column that may already have data, use this:

DBCC CHECKIDENT ("Tab1", RESEED, 1000);

[Gandalf_TheWhite]

That worked!! Thanks Abhijit :thumbsup:

Believe Yourself™

[Gandalf_TheWhite]

Both worked. Thanks. :thumbsup: Actually I am going to start it from 300000. Does this huge starting number could create any issue when the records increases?? If there would be any limitation for increasing the amount of the records in future then also please mention. :thumbsup:

Believe Yourself™

[Abhijit Jana]

Great ! ;)

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

[Lost User]

There is no known problem with using IDENTITY columns. It works well. If you want to really have 'big' numbers, use bigint datatype instead of int. The syntax remains the same.