Details

Identity, Sequence and ROW_NUMBER

Speaker: Itzik Ben-Gan

Duration: 60 minutes

Track: 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
cage-aids
cage-aids
cage-aids