复制declare @temp table ( [id] int IDENTITY(1,历表录1), [Name] varchar(10) ) declare @tempId int,@tempName varchar(10) insert into @temp values(a) insert into @temp values(b) insert into @temp values(c) insert into @temp values(d) insert into @temp values(e) --select * from @temp WHILE EXISTS(select [id] from @temp) begin SET ROWCOUNT 1 select @tempId = [id],@tempName=[Name] from @temp SET ROWCOUNT 0 delete from @temp where [id] = @tempId print Name:----+@tempName end 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.