记录，直接上代码：

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。