NewIdInterval Procedure (Repository Schema)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Returns one or more unique identifiers for the given sequence object or sequence alias.
[Repository].[NewIdInterval] ( @schema, @sequence, @intervalSize, @firstValue OUTPUT )
Arguments
@schema
Type: sysname. The schema of the sequence object or sequence alias.
@sequence
Type: sysname. The name of the sequence object or sequence alias.
@intervalSize
Type: int. The number of identifiers to obtain.
@firstValue
Type: bigint. An OUTPUT parameter that holds the value of the first identifier. If @intervalSize is greater than one, then the remaining identifiers are offsets from this initial value. This is an OUTPUT parameter.