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

来源：互联网发布：佛山网页美工培训编辑：程序博客网时间：2024/05/20 19:29

游标的使用示例

declare @EI_SendID intdeclare @EI_Order varchar(20)declare @i intdeclare cur_EU_Name cursor for SELECT [inKid],[EU_EMAIL] FROM [SQL_XueTrade].[dbo].[EM_USER] where [EU_Name] like 'ck_ST%'open cur_EU_Namefetch NEXT from cur_EU_Name into @EI_SendID,@EI_Orderwhile @@FETCH_STATUS = 0begin       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_Orderend---最后关闭和释放游标CLOSE cur_EU_Name   --关闭游标DEALLOCATE cur_EU_Name  --释放游标

0 0