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.
Exercise 1: INSERT Sequence numbers into a table
Exercise 2: Generate sequence numbers in the SELECT statement
Exercise 3: Generate repeating sequence numbers in the result set
Exercise 4: Generate sequence numbers using OVER clause
Exercise 5: Self-Assessment
Exercise 6: T-SQL Challenge