exec sp_executesql N'WITH SearchResult AS <BR>(&nbsp;&nbsp; SELECT Row_Number() OVER (ORDER BY&nbsp; @SortExpression +'' '' + @SortDirection) AS RowID, <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UserID,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FirstName,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LastName,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UserName,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status,<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UserRole<BR>&nbsp;&nbsp;&nbsp; FROM dbo.Users<BR>&nbsp;&nbsp;&nbsp; WHERE (Status = @Status OR @Status = -1) <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AND (FirstName LIKE <A href="mailto:''%''+@Keyword+''%''">''%''+@Keyword+''%''</A> OR LastName LIKE <A href="mailto:''%''+@Keyword+''%''">''%''+@Keyword+''%''</A> OR UserName LIKE <A href="mailto:''%''+@Keyword+''%''">''%''+@Keyword+''%''</A> OR&nbsp; @Keyword = '''')<BR>) SELECT * FROM SearchResult WHERE RowID &gt; @PageIndex * @PageSize AND RowID &lt;= (@PageIndex + 1) * @PageSize',<BR><A href="mailto:N'@Keyword">N'@Keyword</A> nvarchar(4000),@Status int,@PageIndex int,@PageSize int,@SortExpression nvarchar(8),@SortDirection nvarchar(4)',<BR>@Keyword=N'',@Status=-1,@PageIndex=0,@PageSize=1,@SortExpression=N'USERNAME',@SortDirection=N'asc'<BR>在上面的SQL语句中指定的排序参数 @SortExpression @SortDirection为什么不起作用，无论@SortDirection=N'asc'还是@SortDirection=N'desc'，执行的结果始终是一样的顺序？