34,590
社区成员
发帖
与我相关
我的任务
分享
declare mycursor cursor for select id from v_character
declare @i int
open mycursor
fetch next from mycursor into @i
WHILE @@FETCH_STATUS = 0
BEGIN
select * from tb where id=@i --此处作你的其他查询
FETCH NEXT FROM mycursor INTO @i
END
close mycursor
deallocate mycursor