How to create sequence in sql server

Question

How can we create sequence in SQL Server? I am creating like this

CREATE SEQUENCE counter
AS INT
MINVALUE 1
NO MAXVALUE
START WITH 1;

but getting below error

Msg 343, Level 15, State 1, Line 1
Unknown object type 'SEQUENCE' used in a CREATE, DROP, or ALTER statement.

Thanks in advance

Which version MS SQL Server do you use ? As I know SEQUNCE's have been added only in 2012 version. — ceth
– ceth, Commented Feb 27, 2014 at 10:56

Dale K · Accepted Answer · 2020-04-16 02:11:44Z

6

CREATE SEQUENCE CountBy1
    START WITH 1
    INCREMENT BY 1 ;

    SELECT next value for CountBy1

In SQL Server 2012 above is the syntax to create and consume created sequence.

Dale K

28.1k15 gold badges59 silver badges86 bronze badges

answered Feb 27, 2014 at 10:57

Ketan Panchal

2301 gold badge2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sequences have been added only in 2012 version

By mistake i wrote 2008 version. i have updated the given answer.