记录，直接上代码：
SET NOCOUNT ON
DECLARE @t TABLE
(
id INT
)
INSERT INTO @t(id) SELECT 列名 FROM 表名 ORDER BY 列名
DECLARE @c INT
SET @c=(SELECT COUNT(1) FROM @t)
PRINT 'counts:'+CAST(@c AS VARCHAR)
DECLARE @i INT
SET @i=(SELECT TOP 1 id FROM @t ORDER BY id)
WHILE @i IS NOT NULL
BEGIN
PRINT 'id:'+CAST(@i AS VARCHAR)
DELETE FROM @t WHERE id=@i
SET @i=(SELECT TOP 1 id FROM @t ORDER BY id)
END
SET NOCOUNT OFF
其中 SET NOCOUNT ON 的意思为不在查询结果窗口显示影响行统计数（如 XX 行受影响），该设置项默认值为 OFF。