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

File Size730.91 KB
Create DateSeptember 12, 2016
Last UpdatedSeptember 12, 2016