在SqlServer2005可以用括号把百分比括起来,但SqlServer2000不行
如:
SELECT TOP (100) PERCENT from table1在sqlserver2005运行正常,在sqlserver2000中运行不正常,
SqlServer2000中必须是SELECT TOP 100 PERCENT from table1,否则报错
在SqlServer2005可以用括号把百分比括起来,但SqlServer2000不行
如:
SELECT TOP (100) PERCENT from table1在sqlserver2005运行正常,在sqlserver2000中运行不正常,
SqlServer2000中必须是SELECT TOP 100 PERCENT from table1,否则报错