无法在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 Server 2008中创建序列,SQL Server 2008中的序列对象未找到它是否已过时?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我无法在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屋!
查看全文