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)beginprint '--1---'set ROWCOUNT 1            SELECT @tempId=[SheBeiId] FROM @tmpTBset ROWCOUNT 0delete from @tmpTB where [SheBeiId]=@tempIdprint '[SheBeiId]:----'+@tempId end