摘要：
CREATEPROCEDUREp_GetStudentInfo @PageSizeINT, @PageIndexINT, @strWherevarchar(1500)--查询条件(注意:不要加where) As Begin select*from( selectrow_number()over(orderbyStudentInfoId)row,*fromStudentInfo)StudentInfo whererowbetween@PageSize*(@PageIndex-1)and@PageSize*@PageIndex End go通用方法USE [OrderDB]... 阅读全文
