sql server 2005下奇怪的Delete Top 语句(downmoon)

sql server 2005中Delete语句可以添加一个top参数

以下示例删除 Testdb 表中所有行的 10%。

-- 生成测试数据库
Create database Testdb
go
USE [ Testdb ]
GO
-- 生成测试表
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [ dbo ] . [ TestDelete ] (
[ PKID ] [ int ] IDENTITY ( 1 , 1 ) NOT NULL ,
[ TestID ] [ int ] NULL ,
[ testString ] [ nvarchar ] ( 50 ) NULL ,
CONSTRAINT [ PK_TestDelere ] PRIMARY KEY CLUSTERED
(
[ PKID ] ASC
) WITH (PAD_INDEX = OFF ,STATISTICS_NORECOMPUTE = OFF ,IGNORE_DUP_KEY = OFF ,ALLOW_ROW_LOCKS = ON ,ALLOW_PAGE_LOCKS = ON ) ON [ PRIMARY ]
) ON [ PRIMARY ]
go
-- 插入测试数据
declare @tmpID int
set @tmpID = 1
WHILE (( SELECT max (PKID) FROM TestDelete) < 2000 )
BEGIN
set @tmpID = @tmpID + 2
insert into [ TestDelete ] ( [ TestID ] , [ testString ] ) values ( @tmpID , cast ( @tmpID as nvarchar ( 10 )))
CONTINUE
END

select count ( * ) from TestDelete
go
-- 删除测试数据
--以下示例删除 Testdb 表中所有行的 10%。
DELETE TOP ( 10 ) PERCENT FROM TestDelete
GO
-- 下面这句执行错误
-- --DELETETOP(10)PERCENTFROMTestDeleteorderbyPKIDdesc
-- --GO
select count ( * ) from TestDelete
go

-- 删除测试数据库
-- --dropdatabaseTestdb
-- --go

微软的开发人员真的很奇怪？不得而知。一个奇怪的语句。