在视图中用order by数据库教程 -电脑资料

    视图

    大家知道

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

在视图中用order by数据库教程

电脑资料