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查一下，确实已经正确排序。