Forcing an IDENTITY column to have a certain value

#1

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

#2

Weyus wrote:

Quote:

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 Guzowski
http://guzowski.info

#3

On Jun 27, 3:28 pm, "Marcin A. Guzowski"
<tu_wstaw_moje_i... (AT) guzowski (DOT) info> wrote:

Quote:

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

#4

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

BEGIN TRANSACTION

INSERT INTO my_table DEFAULT VALUES

ROLLBACK TRANSACTION

HTH,
Gert-Jan

Weyus wrote:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Forcing an IDENTITY column to have a certain value

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Forcing an IDENTITY column to have a certain value - 06-27-2007 , 03:11 PM

Re: Forcing an IDENTITY column to have a certain value - 06-27-2007 , 03:28 PM

Re: Forcing an IDENTITY column to have a certain value - 06-27-2007 , 04:02 PM

Re: Forcing an IDENTITY column to have a certain value - 06-28-2007 , 02:31 PM