分页查询的SQL存储过程

select top 5 * from student

alter procedure selectTopN
@count int
as
begin
declare @topCount varchar(1000)
set @topCount='select top '+convert(varchar,@count)+' * from student'
exec(@topCount)
end
 

exec selectTopN 10