[邀月博客] SQL Server 2008中SQL增强之二：Top新用途

top数为变量时

declare @intTop int
set @intTop=2
print @intTop

--set rowcount @intTop
--select * from [dbo].[Demo_Values]
select top @intTop * from [dbo].[Demo_Values]