SQL Server Performance Forum – Threads Archive
What equals to Oracleâ€™s SequenceHi, What equals to Oracle#%92s Sequence in MSSQL Server 2000? and how to use in Procedure or in Function. Regards
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.