1：如下查詢(xún)語(yǔ)句沒(méi)問(wèn)題 select * from sysobjects order by name 2：如果把該查詢(xún)語(yǔ)句建成視圖 create view v_test as select * from sysobjects order by name 會(huì)提示出錯(cuò): the order by clause is invalid in views, inline functions, derived tables, and subqueries, unless top is also specified.
3: 既然提示除非在語(yǔ)句中使用top 才能用order by，那就好說(shuō)了 create view v_test as select top 100 percent * from sysobjects order by name
一切正常 再用select * from v_test查一下，確實(shí)已經(jīng)正確排序。
