DECLARE @id int;

DECLARE @title VARCHAR(256),@author VARCHAR(128);

SET @id=(SELECT TOP 1 id FROM @table1 ORDER BY id);

WHILE @id IS NOT NULL
BEGIN
     SELECT
         @title=title,
         @author=author
     FROM @table1 
     WHERE id=@id;

     EXEC  proc_xxx @id,@title,@author;

     SET @id=(SELECT TOP 1 id FROM @table1 WHERE id>@id ORDER BY id);
END

------解决方案--------------------
探讨

那怎么使用游标啊


------解决方案--------------------
探讨

引用:
那怎么使用游标啊 
 

SQL code
--游标的基本写法
declare @id int,@name varchar(20);
declare cur cursor fast_forward for
  select id,name from a;
open cur;
fetch next from cur into @id,@name;
while @@fetch_status=0
begin
   --做你要做的事
   fetch next from cur into @id,@name;
end
close cur;
deallocate cur;




SQL codeSQL游标原理和使用方法
http://t…