Write flexible and performant code with NumberSequences

Enabled for	Public preview	General availability
Users by admins, makers, or analysts	Apr 1, 2024	Apr 1, 2024

Business value

Improvements to the NumberSequences date type streamlines the development and execution of code that creates and manages number sequences in the database. You get increased efficiency and speed.

Feature details

This release offers the following improvements to the NumberSequences data type:

• New Restart operation

  Before this release, you had to delete and recreate a number sequence to restart it. Now, the new Restart operation simplifies and speeds up this process. The operation uses the following syntax:

  Restart(name: text; seed: BigInteger; CompanySpecific: bool)
  

• New RangeStart operation

  The new RangeStart operation lets you request multiple values from the number sequence at once. This approach eliminates gaps and reduces SQL round-trips. The operation uses the following syntax:

    RangeStart : = Range(name: text; count: integer; CompanySpecific: bool);
  

• Improved Next, Current, and Exists operations

  These operations are now 8 to 32 percent faster.

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Additional resources

NumberSequence Data Type (docs)