Re: Forcing an IDENTITY column to have a certain value

From: Weyus <weyus@xxxxxxx>
Date: Wed, 27 Jun 2007 21:02:19 -0000

On Jun 27, 3:28 pm, "Marcin A. Guzowski"
<tu_wstaw_moje_i...@xxxxxxxxxxxxx> wrote:

Weyus wrote:

All,

Is there any way to _set_ an IDENTITY column to have a certain value
so as to create a gap in the set of identity values on purpose?

All I've found is SET IDENTITY_INSERT.

There is also a DBCC command:
DBCC CHECKIDENT ('table_name', reseed, new_value)

--
Best regards,
Marcin Guzowskihttp://guzowski.info

Thanks,
That's what I needed!

Wes

.

References:
- Forcing an IDENTITY column to have a certain value
  - From: Weyus

Prev by Date: Re: How to reliably ensure that only one set of rows is bulk imported into a table at a time
Next by Date: Re: How to reliably ensure that only one set of rows is bulk imported into a table at a time
Previous by thread: Forcing an IDENTITY column to have a certain value
Next by thread: Re: Forcing an IDENTITY column to have a certain value
Index(es):
- Date
- Thread