在开发数据库服务器上是可以运行的,在正式运行的服务器上就出错,为什么?请高手赐教!
---------------------------------------------------------------
有两种办法:
1.
select top 10 * from tablename where ...
select top 10 col1,col2,...coln from tablename where...
2.
set rowcount 10
select * from tablename where ...
select col1,col2,...coln from tablename where...
set rowcount 0