动态游标

举个例子，你再根据你的具体情况进行修改：

declare @sqlExec varchar(8000),@tableName varchar(255)
set @tableName = "sysobjects"
set @sqlExec = "declare cursor1 cursor for " + CHAR(13)
set @sqlExec = @sqlExec + " select * from " + @tableName
exec(@sqlExec)
open cursor1
fetch next from cursor1 ---如果要放在变量中请写into <变量列表>
while @@fetch_status = 0
......
fetch next from cursor1 ---如果要放在变量中请写into <变量
end
close cursor1
deallocate cursor1