sql-server - SQL Server 2000 "Select is broken"带有 TOP 子句

Question

使用 SQL Server 2000 Developer Edition，为什么会出现这样的代码:

select top 10 * from table

导致这个错误:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '10'.

和这个代码:

select * from master m
left join locality l on m.localityid = l.localityid

导致这个错误:

Server: Msg 170, Level 15, State 1, Line 2 Line 2: Incorrect syntax near 'left'.

Answer 1

答案是数据库兼容性。它被设置为 60，应该是 80。

这是来自 http://msdn.microsoft.com/en-us/library/bb510680.aspx 的摘录

The value must be one of the following:
- 80 = SQL Server 2000
- 90 = SQL Server 2005
- 100 = SQL Server 2008

我把它改成 80，现在一切都很好。