Posted by Gert-Jan Strik on 06/28/07 19:31

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

• Next in forum: Re: Performance between Standard Join and Inner Join
• Prev in forum: Re: Is Not Null and Query Optimization
• Thread view: Re: Forcing an IDENTITY column to have a certain value

[Reply to this message]