SQL游标循环取值的两个实例

107 阅读 0 评论 71 点赞

我是靠谱客的博主爱笑凉面，这篇文章主要介绍SQL游标循环取值的两个实例，现在分享给大家，希望可以做个参考。

实例1：

declare @maxid int
declare @zhibanren nvarchar ( 30 )
declare @shoujihao nvarchar ( 30 )
declare @banci nvarchar ( 5 )
declare @zhibanshijian datetime
select @maxid = ID from safe_message_zhibanbiao where day ( getdate ()) = day (zhibanshijian)
if @maxid <> 4
   begin
       declare Type_Cursor CURSOR FOR select zhibanren,shoujihao,banci,zhibanshijian from safe_message_zhibanbiao where day ( getdate ()) = day (zhibanshijian)
       open Type_Cursor
       fetch next from Type_Cursor into @zhibanren , @shoujihao , @banci , @zhibanshijian
       while ( @@fetch_status = 0 )
         begin
           insert into safe_message_dangqianzhiban values ( @zhibanren , @shoujihao , @banci , @zhibanshijian )
           fetch next from Type_Cursor into @zhibanren , @shoujihao , @banci , @zhibanshijian
         end
       CLOSE    Type_Cursor
       DEALLOCATE    Type_Cursor
end

实例2：

declare cur cursor
read_only
for select PName from Point

declare @name varchar ( 40 )
open cur

fetch next from cur into @name
while ( @@fetch_status = 0 )
begin
print @name

fetch next from cur into @name
end

close cur
deallocate cur
go