语句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