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

by

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.

More Related Contents:

  1. LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
  2. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  3. Find a value anywhere in a database
  4. Function to Calculate Median in SQL Server
  5. How to check if a column exists in a SQL Server table
  6. Sql Server string to date conversion
  7. How do I create a unique constraint that also allows nulls?
  8. How do I get list of all tables in a database using TSQL?
  9. Select columns from result set of stored procedure
  10. Pass Dictionary to Stored Procedure T-SQL
  11. Escape a string in SQL Server so that it is safe to use in LIKE expression
  12. Get dates from a week number in T-SQL
  13. Date conversion and culture: Difference between DATE and DATETIME
  14. How to check if a database exists in SQL Server?
  15. How to remove accents and all chars a..z in sql-server?
  16. tsql returning a table from a function or store procedure
  17. How can I do something like: USE @databaseName
  18. Find non-ASCII characters in varchar columns using SQL Server
  19. How to split string and insert values into table in SQL Server
  20. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  21. How can I get the sum of multiple datetime values?
  22. How can I determine in SQL Server if a dateTime range overlaps another
  23. Use of Begin / End Blocks and the Go keyword in SQL Server?
  24. How do you determine what SQL Tables have an identity column programmatically
  25. Ampersand (&) operator in a SQL Server WHERE Clause
  26. SQL Server Query – groupwise multiplication
  27. Avg of float inconsistency
  28. how to write number to word function in sql server [closed]
  29. Getting week number off a date in MS SQL Server 2005?
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment