SQL提高旅程2->Sql2005动态取Top Row的几种方式
在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