Forcing an IDENTITY column to have a certain value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Weyus - 27 Jun 2007 21:11 GMT

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.

Thanks,
Wes

Reply to this Message

Marcin A. Guzowski - 27 Jun 2007 21:28 GMT

> 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)

Signature

Best regards,
Marcin Guzowski
http://guzowski.info

Reply to this Message

Weyus - 27 Jun 2007 22:02 GMT

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

> > All,
>
[quoted text clipped - 9 lines]
> Best regards,
> Marcin Guzowskihttp://guzowski.info

Thanks,
That's what I needed!

Wes

Reply to this Message

Gert-Jan Strik - 28 Jun 2007 20:31 GMT

If you only need small gaps, you could simply do this:

BEGIN TRANSACTION

INSERT INTO my_table DEFAULT VALUES

ROLLBACK TRANSACTION

HTH,
Gert-Jan

> All,
>
[quoted text clipped - 5 lines]
> Thanks,
> Wes

Reply to this Message