Oracle sequence but then in MS SQL Server

by

There is no exact match.

The equivalent is IDENTITY that you can set as a datatype while creating a table. SQLSERVER will automatically create a running sequence number during insert.
The last inserted value can be obtained by calling SCOPE_IDENTITY() or by consulting the system variable @@IDENTITY (as pointed out by Frans)

If you need the exact equivalent, you would need to create a table and then write a procedure to retun the next value and other operations. See Marks response on pitfalls on this.

Edit:
SQL Server has implemented the Sequence similar to the Oracle. Please refer to this question for more details.

How would you implement sequences in Microsoft SQL Server?

More Related Contents:

  1. The order of a SQL Select statement without Order By clause
  2. Oracle: is there a tool to trace queries, like Profiler for sql server? [closed]
  3. What is the Oracle equivalent of SQL Server’s IsNull() function?
  4. Sequence as default value for a column
  5. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  6. Max Nbr of Months W/ No Activity in Past 12 Months
  7. Export from SQL Server to Excel
  8. hide/remove header and footer
  9. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  10. SQL Server: SELECT only the rows with MAX(DATE)
  11. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  12. Possible to store value of one select column and use it for the next one?
  13. LEN function not including trailing spaces in SQL Server
  14. How to view transaction logs in SQL Server 2008 [closed]
  15. Scheduled run of stored procedure on SQL server
  16. SQL Server ORDER BY date and nulls last
  17. Best way to implement an audit trail in SQL Server?
  18. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  19. SqlDataAdapter.Fill method slow
  20. What happens to the primary key Id when it goes over the limit?
  21. Will GETUTCDATE() return the same value if used twice in the same statement?
  22. Convert decimal time to hours and minutes
  23. Create table (structure) from existing table
  24. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  25. How can I make SQL Server return FALSE for comparing varchars with and without trailing spaces?
  26. “No backupset selected to be restored” SQL Server 2012
  27. comma delimited list as a single string, T-SQL [duplicate]
  28. Undesired rounding of DateTime in SQL Server
  29. Why in SQL NULL can’t match with NULL?
  30. Count number of records returned by group by

Leave a Comment