sql 遍历记录

declare @tempId  varchar(100) ,@tempName  varchar(100)
declare @tmpTB table
(
	[SheBeiId] varchar(100)
)
insert  into @tmpTB ([SheBeiId]) select distinct [SheBeiId] from  [IpcDebugLog]

	while exists (select SheBeiId from @tmpTB)

		begin
print '--1---'
			set ROWCOUNT 1
            SELECT @tempId=[SheBeiId] FROM @tmpTB
			set ROWCOUNT 0
			delete from @tmpTB where [SheBeiId]=@tempId
			print '[SheBeiId]:----'+@tempId 


		end