What equals to Oracle’s Sequence | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

What equals to Oracle’s Sequence

Hi, What equals to Oracle#%92s Sequence in MSSQL Server 2000? and how to use in Procedure or in Function. Regards
Srini
There is no equivalent to Oracle sequence. However sequences are typicaly used for autoincrement columns which is supported by identity property. When you insert row with identity column you don’t list this column but its value is assigned automathicaly, you use system function @@IDENTITY to receive last identity inserted. Read BOL for more details.
]]>