游标的使用示例
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 --释放游标