无法在SQL Server 2008中创建序列，SQL Server 2008中的序列对象未找到它是否已过时？ [英] Can't create sequence in SQL server 2008, sequence object in SQL server 2008 not found is it obsolete?

问题描述

我无法在sql 2008中创建序列

I am not able to create sequence in sql 2008

CREATE SEQUENCE [dbo].[NewCounter]
AS INT
START WITH 5
INCREMENT BY 5

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

我尝试了什么：



尝试搜索系统数据库对象但没有解决方案

What I have tried:

tried searching the system db objects but no solution

推荐答案

看看这里： CREATE SEQUENCE（Transact-SQL）| Microsoft Docs [ ^ ]



你可以读到 SEQUENCES适用于：SQL Server（从2012年开始）。如果您想使用序列（从我的观点来看，这是一个非常好的想法），您需要至少升级到2012年。

Have a look here: CREATE SEQUENCE (Transact-SQL) | Microsoft Docs[^]

You can read that SEQUENCES APPLIES TO: SQL Server (starting with 2012). In case you like to use sequences (what is a really good idea from my Point of view) you Need to upgrade at least to 2012.

这篇关于无法在SQL Server 2008中创建序列，SQL Server 2008中的序列对象未找到它是否已过时？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！