游标的使用

declare @ssl_id uniqueidentifier;
declare @ssl_JieSHM varchar(2000);
declare @ssl_FanHZFC varchar(2000);
declare @ssl_FaSRQ datetime;
declare @ssl_JieGuo nvarchar(200);
declare @errno int ;
declare B_Cursor cursor for  select ssl_id,ssl_JieSHM,ssl_FaSRQ from SMSSendLog 
    open B_Cursor;
        fetch next from B_Cursor into @ssl_id ,@ssl_JieSHM,@ssl_FaSRQ
        
        --Begin TransAction
        select '123';
        while @@FETCH_STATUS =0 
           begin
               set @ssl_JieGuo='发送成功！';
               set @ssl_FanHZFC='num=1&success='+@ssl_JieSHM+'&faile=&err=发送成功！&errid=0'; 
               select  @ssl_FanHZFC;
               insert into SMSSendResult values(NEWID(), @ssl_id,@ssl_FaSRQ,@ssl_JieSHM,@ssl_FanHZFC,@ssl_JieGuo)
               fetch next from B_Cursor into @ssl_id ,@ssl_JieSHM,@ssl_FaSRQ
           end
   close B_Cursor;
deallocate B_Cursor;