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

T-SQL Tuesday #116 Roundup – SQL on Linux

By

This month’s topic is wide open to anything you could think of that had...

Adding a Column with a Default Constraint

By

Last week a question came up about adding a column to a table, and...

Rename Azure VM OS Disk

By

In a recent post about creating Azure VMs using PowerShell, I noted a common...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

Query to check the latest windows patch detaisl and last reboot

By ramyours2003

i need a query to check the latest windows patch details and last reboot ...

Remove SQL Server from Failover Cluster

By SJD

Hi, I'm having a problem with a Windows Server 2008 R2 Failover Cluster with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers