启用排序和分页的T-SQL存储过程无法正常工作

以此替换您的过程：

ALTER PROCEDURE [dbo].[usp_get_all_groups]     -- Add the parameters for the stored procedure here    @pStartIndex smallint,    @pPageSize tinyint,    @pOrderBy varchar(15)ASBEGIN SELECt * FROM  (SELECt ROW_NUMBER() OVER (ORDER BY       CASE WHEN @pOrderBy='GroupId ASC' THEN UserGroups._id END ASC,        CASE WHEN @pOrderBy='GroupId DESC' THEN UserGroups._id END DESC,        CASE WHEN @pOrderBy='GroupCode ASC' THEN UserGroups.GroupCode END ASC,      CASE WHEN @pOrderBy='GroupCode DESC' THEN UserGroups.GroupCode END DESC) AS Row,       * FROM UserGroups) AS StudentsWithRowNumbers  WHERe Row>= @pStartIndex AND Row <= @pStartIndex + @pPageSize  ORDER BY Row      END

您不能为非动态表达式动态分配asc和desc。