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
分页查询的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
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
