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.
| Author |
Topic |
|
sebastian11c
Posting Yak Master
129 Posts |
 Posted - 2012-06-26 : 18:47:06
|
| i you want to create an artificial gap between my current seed and starting from a new value to my identity column "idcar"this is my tableCREATE TABLE [dbo].[cars]( [idcar] [int] IDENTITY(1,1) NOT NULL, [make] [varchar](50) NULL, [codeline] [int] NULL, [year] [int] NULL,and currently the next value to idcar column is 678 and i want to create a gap to start from the value 2500 for my idcar columnhow could i do it??im creating this gap because i have a project and i need to reserve the idcar column from value 678 to 2499 to fill a month latermany many thanks in advanced for your help |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-06-26 : 19:36:57
|
| DBCC CHECKIDENT([dbo].[cars], RESEED, 2500) |
 |
|
|
|
|
|
identity , create an artificial gap