视图里 ORDER BY 错误 小弟我不明白－－那位大侠帮帮忙

[getbyling]

本人写一视图如下：

CREATE VIEW Law_View
AS
select Law_ID,
Law_Title
from LAW where Law_Use<>'n'
order by Law_AddTime desc
GO

但提示错误如下：
服务器: 消息 1033，级别 15，状态 1，过程 Law_View，行 5
除非同时指定了 TOP，否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。

[getbyling]

我不是要完成读出全部数据，并不是用TOP 读出指定的几条

[wzh1215]

CREATE VIEW Law_View
AS
select Law_ID,Law_Title,Law_AddTime
from LAW where Law_Use<>'n'
order by Law_AddTime desc
GO

[getbyling]

本人在线

[libin_ftsate]

CREATE VIEW Law_View
AS
select top 100 PERCENT
Law_ID,
Law_Title
from LAW where Law_Use<>'n'
order by Law_AddTime desc
GO