Identity, Sequence and ROW_NUMBER

Itzik Ben-Gan
60 minutes
Track #1
This session is about tools in T-SQL that allow you to generate a sequence of values, often used as surrogate keys, but sometimes for other purposes. The session covers the identity column property and the limitations it imposes. It covers the sequence object which was added in SQL Server 2012. It compares and contrasts the sequence object with the identity property, including a performance comparison. If time permits, the session will also discuss generating sequences of integers with the ROW_NUMBER function, and describe some creative ways to use it.

Accompanying Material

No material found.

Back to Top cage-aids