SQL Server v.Next (Denali) : Using SEQUENCE
SQL Server 2011 introduces a feature that Oracle professionals will certainly recognize: SEQUENCE. SEQUENCE allows you to define a central place where SQL Server will maintain a counter of values for you. The last-used...