T-SQL SEQUENCE runs out, no cycle, what happens?

The documentation you mentioned specifies what happens: “[…] throw an exception when its minimum or maximum value is exceeded”

Regarding the error message you can find out using a simple Google search: https://www.google.com/search?q=t-sql+error+messages+sequence The fourth link is https://www.sqlshack.com/sequence-objects-in-sql-server/ and there you can find a screenshot of the error, which has the number 11728.

Of course, it would be easier to try it yourself, using one of the methods already specified in the comments.

Browse More Popular Posts

Leave a Comment