The IDENTITY Property: A Much-Maligned Construct in SQL Server

"It’s not that there aren’t cases in which an IDENTITY just won’t do, or really isn’t the best choice. There are more than a few places where another construct is better, and we’ll go into them in a minute. It’s just that, for the vast majority of auto-numbering scenarios, setting the IDENTITY property is the way to go."