sequence

SQL Server SEQUENCE Basics

  • Article

The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is a great relief to database professionals as it solves some problems what are awkward to solve with the IDENTITY property. Joe Celko explains the basics of using a SEQUENCE.

2014-02-19

5,839 reads

Blogs

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Daily Coping 4 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Read the latest Blogs

Forums

Nested Join Alternative

By Jackie Lowery

Is there a better way to write this nested join query?  I'm concerned about...

How to determine whether SSIS is being used?

By jankovic

Hello I've inherited some dev environment which looks like was abandoned, but I'd like...

xml output from sql query

By Bruin

The script runs but gives me "no data to export"  I see data in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers