sql server 2005下奇怪的Delete Top 语句
sql server 2005中Delete语句可以添加一个top参数以下示例删除 Testdb 表中所有行的 10%。
--生成测试数据库
Create database Testdb
go
USE
GO
--生成测试表
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE .(
IDENTITY(1,1) NOT NULL,
NULL,
(50) NULL,
CONSTRAINT PRIMARY KEY CLUSTERED
(
ASC
)WITH (PAD_INDEX= OFF, STATISTICS_NORECOMPUTE= OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS= ON, ALLOW_PAGE_LOCKS= ON) ON
) ON
go
--插入测试数据
declare @tmpID int
set @tmpID=1
WHILE ( (SELECT max(PKID) FROM TestDelete)
页:
[1]