语句1：exec sp_executesql N'SELECT * FROM

(SELECT [Id],[Course_id],[Ques_type_key],[Ques_type_name],

ROW_NUMBER() OVER(ORDER BY @Const0 ASC) AS RowIndex

FROM [Ques_type_dict]

WHERE ( [Course_id] =@constant1)) T

WHERE RowIndex BETWEEN 1 AND 30',

N'@Const0 nvarchar(4000),@constant1 int',

@Const0=N'ques_type_key',@constant1=1

语句2（同语句1的sql语句）：

SELECT * FROM

(SELECT [Id],[Course_id],[Ques_type_key],[Ques_type_name],

ROW_NUMBER() OVER(ORDER BY ques_type_key ASC) AS RowIndex

FROM [Ques_type_dict]

WHERE ( [Course_id] =1)) T

WHERE RowIndex BETWEEN 1 AND 30

语句1执行结果排序字段没有起作用

语句2正常

sql语句：

监控结果：

从监控结果看语句1少了排序动作，

求解答，什么原因导致，怎么解决！

备注：数据库是SqlServer2008R2