其实你这边100 percent就等于全部返回
而全部返回就等于不写
另外如果你的SELECT里面不写TOP,又要用ORDER是不能创建VIEW的
----
Msg 1033, Level 15, State 1, Procedure v_t1, Line 5
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.
----
矛盾估计就在这边了。
For my test, it is really a little bit wired~~
--
CREATE TABLE [dbo].[t1](
[ID] [int] NOT NULL,
[index] [int] NULL,
CONSTRAINT [PK_t1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]