SQL脚本积累之六-----游标的使用示例

最新推荐文章于 2023-08-11 21:15:59 发布

心在天涯

最新推荐文章于 2023-08-11 21:15:59 发布

阅读量638

点赞数

分类专栏： SQL Server数据库文章标签： sql 游标

本文链接：https://blog.csdn.net/jiang1986829/article/details/46955707

版权

SQL Server数据库专栏收录该内容

6 篇文章 0 订阅

订阅专栏

游标的使用示例

declare @EI_SendID int
declare @EI_Order varchar(20)
declare @i int

declare cur_EU_Name cursor for SELECT [inKid],[EU_EMAIL] FROM [SQL_XueTrade].[dbo].[EM_USER] where [EU_Name] like 'ck_ST%'
open cur_EU_Name
fetch NEXT from cur_EU_Name into @EI_SendID,@EI_Order
while @@FETCH_STATUS = 0
begin   
    set @i =0 
    select @i=count(*) FROM [SQL_XueTrade].[dbo].[EM_USER] where [EU_Name] like 'ck_ST%'

    insert into [SQL_XueTrade].[dbo].[EM_Info]([EI_SendID],[EI_GetID],[EI_TOPIC],[EI_NOTE],[EI_date],[EI_State],[EI_ISREAD],[EI_encloure],[EI_Owener],[EI_Order])
    values(@EI_SendID,43,'aa','bb','2013-12-09 16:22:24.000',0,1,'',43,'jks_ST003@gtadata.com')

    insert into [SQL_XueTrade].[dbo].[EM_Info]([EI_SendID],[EI_GetID],[EI_TOPIC],[EI_NOTE],[EI_date],[EI_State],[EI_ISREAD],[EI_encloure],[EI_Owener],[EI_Order])
    values(@EI_SendID,0,'aa','bb','2013-12-09 16:22:24.000',1,0,'',@EI_SendID,'jks_ST003@gtadata.com')

    insert into [SQL_XueTrade].[dbo].[EM_Info]([EI_SendID],[EI_GetID],[EI_TOPIC],[EI_NOTE],[EI_date],[EI_State],[EI_ISREAD],[EI_encloure],[EI_Owener],[EI_Order])
    values(43,@EI_SendID,'aa','bb','2013-12-09 16:22:24.000',0,1,'',@EI_SendID,@EI_Order)

    insert into [SQL_XueTrade].[dbo].[EM_Info]([EI_SendID],[EI_GetID],[EI_TOPIC],[EI_NOTE],[EI_date],[EI_State],[EI_ISREAD],[EI_encloure],[EI_Owener],[EI_Order])
    values(43,0,'aa','bb','2013-12-09 16:22:24.000',1,0,'',43,@EI_Order)
    --取下一个记录进行统计
    fetch NEXT from cur_EU_Name into @EI_SendID,@EI_Order
end
---最后关闭和释放游标
CLOSE cur_EU_Name   --关闭游标
DEALLOCATE cur_EU_Name  --释放游标