Sql Server 2008游标使用 

 1 declare @ssl_id uniqueidentifier;
 2 declare @ssl_JieSHM varchar(2000);
 3 declare @ssl_FanHZFC varchar(2000);
 4 declare @ssl_FaSRQ datetime;
 5 declare @ssl_JieGuo nvarchar(200);
 6 declare @errno int ;
 7 declare B_Cursor cursor for  select ssl_id,ssl_JieSHM,ssl_FaSRQ from SMSSendLog 
 8     open B_Cursor;
 9         fetch next from B_Cursor into @ssl_id ,@ssl_JieSHM,@ssl_FaSRQ
10         
11         --Begin TransAction
12         select '123';
13         while @@FETCH_STATUS =0 
14            begin
15                set @ssl_JieGuo='发送成功！';
16                set @ssl_FanHZFC='num=1&success='+@ssl_JieSHM+'&faile=&err=发送成功！&errid=0'; 
17                select  @ssl_FanHZFC;
18                insert into SMSSendResult values(NEWID(), @ssl_id,@ssl_FaSRQ,@ssl_JieSHM,@ssl_FanHZFC,@ssl_JieGuo)
19                fetch next from B_Cursor into @ssl_id ,@ssl_JieSHM,@ssl_FaSRQ
20            end
21    close B_Cursor;
22 deallocate B_Cursor;

 

posted @ 2013-09-25 14:38  梦的海洋  阅读(9739)  评论(0)    收藏  举报