In Transact-SQL (T-SQL) 2012 SEQUENCE is a user-defined object to generate sequence of numbers based on the specifications while created. NEXT VALUE FOR function generates sequence number from the specified SEQUENCE object. This lab is divided into six exercises explaining the usage of SEQUENCE in different scenarios such as inserting sequence number into a table, generate sequence numbers in the select statement, generating sequence numbers in result set, generate sequence numbers using OVER clause.

Subscribe to Download


Version1.0
Download4
File Size730.91 KB
Create DateSeptember 12, 2016
Last UpdatedSeptember 12, 2016
Optimizing SQL Server Stored Procedures
SQL Server Execution Plans