CSDN博客

img txlicenhe

在视图中用order by

发表于2004/3/21 17:30:00  1366人阅读

分类: SQL

大家知道

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

0 0

相关博文

我的热门文章

img
取 消
img