SQL中游标的使用，还希望能给出清晰的例子。

我没在公司回去给你发，这个东西还是少使用。容易出问题的
这个例子你看看

CREATE PROCEDURE dbo.CCSR_LJH_JH
(
@cardcoding varchar(50),
@AgentName varchar(50),
@Grade varchar(50)--激活类别
)
AS

declare @card varchar(50)
declare @cardpassword varchar(50)
declare @value varchar(20)
declare @time datetime
declare @Endtime datetime
declare @cardID varchar(500)
if @Grade='卡号'
begin
set @cardpassword=(select top 1 cardpassword from ccsr_callback_cardtemp where cardcoding=@cardcoding )--QDCardCoding
set @value=(select top 1 value from ccsr_callback_cardtemp where cardcoding=@cardcoding )
set @time=(select top 1 starttime from ccsr_callback_cardtemp where cardcoding=@cardcoding )
set @cardID=(select top 1 cardid from ccsr_callback_cardtemp where cardcoding=@cardcoding )
insert into ccsr_callback_card(cardcoding,cardpassword,value,Istrue,starttime,cardid,cardcondition,AgentName) values (@cardcodin