Datastore Sequence in SQLServer

[VasiliyRepecki]

Hi.

I newbie in SQL.

I created sequence as described in "Persistence Datastore Sequence Customization" chapter of customization guide:

CREATE TABLE wt_sequence_<MySequence> (dummy CHAR(1),

value BIGINT IDENTITY(<MySequenceSeed>,<MySequenceIncrement>))

go

CREATE PROCEDURE wt_get_next_sequence_<MySequence> @returnValue BIGINT OUTPUT

AS

INSERT wt_sequence_<MySequence> (dummy) VALUES ('x')

SELECT @returnValue = SCOPE_IDENTITY()

go

For testing period i set MySequenceSeed = 1.

How can i later change MySequenceSeed ?

Thanks.

[VasiliyRepecki · Accepted solution]

Next code changes sequence start = 20:

SET IDENTITY_INSERT wt_sequence_<MySequence> ON;

GO

INSERT wt_sequence_<MySequence> (dummy, value) VALUES ('x', 19)