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

[Back to original message]