SQL SERVER 2005 FASTFIRSTROW 問題

[Dear SQL(燊)]

大家好﹐請問以下語句在SQL SERVER 2000可以執行﹐前段時間在SQL SERVER 2005都能執行
select top 1 part_no FROM PARTFLM T1 (nolock FASTFIRSTROW index =IX_PARTFLM) where part_no='cw'
但現在在SQL SERVER 2005(與前段時間在SQL SERVER 2005是同一服務器)中老出現下面錯誤﹕
Msg 1018, Level 15, State 1, Line 1
Incorrect syntax near 'FASTFIRSTROW'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.

[--小F--]

锁的影响？

[SQL77]

不懂

[Dear SQL(燊)]

[Quote=引用 1 楼 fredrickhu 的回复:]
锁的影响？
[/Quote]
請問怎么解決

[xman_78tom]

select top 1 part_no FROM PARTFLM T1 with (nolock FASTFIRSTROW index =IX_PARTFLM) where part_no='cw'

[忆轩辕]

--应该没什么问题，根据提示加上with看看

select top 1 part_no FROM PARTFLM T1 (nolock FASTFIRSTROW index =IX_PARTFLM) where part_no='cw'

[忆轩辕]

好像是index前面的空格是中文空格？

select top 1 part_no FROM PARTFLM T1 with(nolock FASTFIRSTROW index =IX_PARTFLM) where part_no='cw'

--看看行不行

[Dear SQL(燊)]

謝謝各位﹗問題已解決^_^

[xman_78tom]

If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required.