如何使用游标付值

[zhangwz20]

请问如何使用游标给每一行付值，最好给出简单例子，谢谢！

[了缘]

fetch next into @1,@2,@3,....

[zjcxc]

不明白楼主的意思.

[了缘]

CREATE PROCEDURE p_ZHZTotalAccept
@strAgent as varchar(40)
AS
begin

DECLARE @agent varchar(50),@name varchar(50),@TotalCount int
DECLARE agentAccept_cursor CURSOR
FOR
select cName,name,count(*) as TotalCount
from Test.dbo.agent
group by cName,name
order by cName
OPEN agentAccept_cursor
FETCH NEXT FROM agentAccept_cursor
INTO @agent,@name,@TotalCount
WHILE @@FETCH_STATUS=0
BEGIN
INSERT INTO t_MyTest(agent,Name,TotalCount) VALUES (@agent,@name,@TotalCount)
FETCH NEXT FROM agentAccept_cursor
INTO @agent,@name,@TotalCount
END
CLOSE agentAccept_cursor
DEALLOCATE agentAccept_cursor
end


参考一下