sql不使用游标遍历表数据

create table nametable(
nameguid uniqueidentifier,
name nvarchar(10)
)
insert into nametable(nameguid,name) values(newid(),‘lide‘)
insert into nametable(nameguid,name) values(newid(),‘lideqiang‘)
insert into nametable(nameguid,name) values(newid(),‘liqiang‘)

set rowcount 1
select * from nametable

declare @nameguid uniqueidentifier

declare @name nvarchar(10)

while exists (select * from nametable)

begin

set rowcount 1

select @nameguid = nameguid from nametable

select @name = name from nametable where nameguid = @nameguid

set rowcount 0

delete from nametable where nameguid = @nameguid

print @name

end

select * into #nametable from nametable