• Don't assume that these identities will always be consecutive though - there may be gaps in the sequence when you look at the data.

    An interesting article with examples of manipulating the identity column - http://www.simple-talk.com/sql/t-sql-programming/identity-columns/.