在SQL2005中,取Top 有两种方式
1. 使用Top关键字
declare
@Number
int
set @Number = 1
select top ( @Number ) * from users
set @Number = 1
select top ( @Number ) * from users
2.使用set rowcount关键字
declare @Number int
set @Number = 1
set rowcount @Number
select * from users
set rowcount 0