--生成测试数据库 Createdatabase Testdb go USE[Testdb] GO --生成测试表 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATETABLE[dbo].[TestDelete]( [PKID][int]IDENTITY(1,1) NOTNULL, [TestID][int]NULL, [testString][nvarchar](50) NULL, CONSTRAINT[PK_TestDelere]PRIMARYKEYCLUSTERED ( [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@tmpIDint set@tmpID=1 WHILE ( (SELECTmax(PKID) FROM TestDelete)<2000 ) BEGIN set@tmpID=@tmpID+2 insertinto[TestDelete] ([TestID],[testString]) values(@tmpID,cast(@tmpIDasnvarchar(10))) CONTINUE END selectcount(*) from TestDelete go --删除测试数据 --以下示例删除 Testdb 表中所有行的 10%。 DELETETOP (10) PERCENTFROM TestDelete GO --下面这句执行错误 ----DELETE TOP (10) PERCENT FROM TestDelete order by PKID desc ----GO selectcount(*) from TestDelete go --删除测试数据库 ----drop database Testdb ----go