sql 存储过程

alter procedure usp_unpss --创建储存方法
@score int 
as 
if(@score<0 or @score>100) 
begin
  print '输入错误'
end
   else
   begin
		select StudentName,StudentResult
		from Student a,Result b
		where a.StudentNo=b.StudentNo
		and StudentResult>@score
   end

exec usp_unpss -20

alter procedure use_Get

 @pageIndex int ,--第几页
 @pageSize int=3 ,--页大小
 @totalRecords int out ,--总记录数
 @totalPages int out--总页面
as
select @totalRecords=count(1) from	Student

select * from 
(
  select *,row_number() over(order by studentNo) as myid
  from Student
)as temp
where myid between (@pageIndex-1)*@pageSize+1 and @pageSize*@pageIndex


declare @record int 
declare @page int 
exec use_Get 2,3,@record out,@page out 
print @record
print @page