[SQL SERVER系列]存储过程，游标和触发器实例[原创]

自己写的存储过程与游标结合使用的实例，与大家分享，也供自己查阅，仅供参考：

--使用游标循环处理，删除重复的记录
    declare @UserID int
    declare @UserName varchar(32)
    declare @RealName varchar(32)
    declare @UnitFlag int
    declare @Email2 varchar(64)
    declare @Mobile varchar(64)
    declare @Start int
    declare @End int
    declare @Type varchar(16)
    declare @IsSubscribe bit
    declare curEmailTotalLib cursor
    for (select UserID,UserName,RealName,UnitFlag,Email,Mobile,IsSubscribe from Task_IntermediateData)
    open curEmailTotalLib                --打开游标
    fetch next from curEmailTotalLib into @UserID, @UserName, @RealName, @UnitFlag, @Email2, @Mobile, @IsSubscribe
    while @@fetch_status = 0   --获取成功
    begin
        --