大家知道
1:如下查询语句没问题
select * from sysobjects order by name
2:如果把该查询语句建成视图
create view v_test
as
select * from sysobjects order by name
会提示出错:
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
3: 既然提示除非在语句中使用top 才能用order by,那就好说了
create view v_test
as
select top 100 percent * from sysobjects order by name
一切正常
再用select * from v_test查一下,确实已经正确排序。
本文地址:http://com.8s8s.com/it/it20954.htm