了解SSMS 2012中的"OFFSET/FETCH" [英] Making sense of 'OFFSET/FETCH' in SSMS 2012
问题描述
今天就安装了Microsoft SQL Server Management Studio 2012.在使自己熟悉ORDER BY的分页功能时,我不断遇到此错误:
Just installed Microsoft SQL Server Management Studio 2012 today. In familiarizing myself with the pagination feature addition of ORDER BY, I keep running into this error:
第15级状态1线5消息102
'OFFSET'附近的语法不正确.
消息153,第15级,状态2,第6行
FETCH语句中选项NEXT的无效用法.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'OFFSET'.
Msg 153, Level 15, State 2, Line 6
Invalid usage of the option NEXT in the FETCH statement.
这是我的查询:
SELECT SingleWomansName, NumberOfCats
FROM CatLadies
WHERE NumberOfCats > 1
ORDER BY NumberOfCats
OFFSET 10 ROWS
FETCH NEXT 5 ROWS ONLY
我看过很多语法相似的how-to文章.是什么赋予了?
I've seen plenty of how-to articles with similar syntax. What gives?
http://msdn.microsoft.com/en-us/library/gg699618.aspx
推荐答案
您确定要连接到SQL Server 2012数据库吗?以下作品:
Are you positive you are connected to a SQL Server 2012 database? The following works:
Select Name, CatCount
From CatLadies
Order By Name
Offset 2 Rows
Fetch Next 2 Rows Only
当我切换到SQL Server 2008时,确实收到了您看到的错误
I do get the error you are seeing when I switch to SQL Server 2008
这篇关于了解SSMS 2012中的"OFFSET/FETCH"的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!