How would you implement sequences in Microsoft SQL Server?

by

Sql Server 2012 has introduced SEQUENCE objects, which allow you to generate sequential numeric values not associated with any table.

Creating them are easy:

CREATE SEQUENCE Schema.SequenceName
AS int
INCREMENT BY 1 ;

An example of using them before insertion:

DECLARE @NextID int ;
SET @NextID = NEXT VALUE FOR Schema.SequenceName;
-- Some work happens
INSERT Schema.Orders (OrderID, Name, Qty)
  VALUES (@NextID, 'Rim', 2) ;

See my blog for an in-depth look at how to use sequences:

http://sqljunkieshare.com/2011/12/11/sequences-in-sql-server-2012-implementingmanaging-performance/

More Related Contents:

  1. Is it possible to use greater than equal to operator in group by? [closed]
  2. Solutions for INSERT OR UPDATE on SQL Server
  3. How to create multiple one to one’s
  4. Querying data by joining two tables in two database on different servers
  5. T-SQL Cast versus Convert
  6. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  7. How Can I use “Date” Datatype in sql server?
  8. How to replace a string in a SQL Server Table Column
  9. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  10. Correct use of transactions in SQL Server
  11. How to run a stored procedure in sql server every hour?
  12. Splitting the string in sql server
  13. Composite Primary key vs additional “ID” column?
  14. Why do you create a View in a database?
  15. Need to list all triggers in SQL Server database with table name and table’s schema
  16. Logging ALL Queries on a SQL Server 2008 Express Database?
  17. How can I do a BEFORE UPDATED trigger with sql server?
  18. The backend version is not supported to design database diagrams or tables
  19. Deferrable Constraints in SQL Server
  20. Know relationships between all the tables of database in SQL Server
  21. Can SQL Server Express LocalDB be connected to remotely?
  22. How do I create and query linked database servers in SQL Server?
  23. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  24. Suggestions for implementing audit tables in SQL Server?
  25. SQL Server search using like while ignoring blank spaces
  26. What does ON [PRIMARY] mean?
  27. How do I list all the columns in a table?
  28. How do I change db schema to dbo
  29. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  30. Space used by nulls in database

Leave a Comment