sql游标的使用和分割字符串

mark防止以后要用到：
分割字符串的函数：
/*
Created By:xumh
Created Date:2013-11-8
Description:SQL分割字符串函数 @str 字符串 @splitchar 分隔符
*/


ALTER     FUNCTION   [dbo].[fn_sys_SplitStr](@str   VARCHAR(8000),@splitchar   VARCHAR(100))   
  RETURNS   @temp   TABLE(ID   VARCHAR(100))   
  AS     
  BEGIN   
  DECLARE   @ch   AS   VARCHAR(100)   
  SET   @[email protected][email protected]     
  WHILE(@str<>'')   
                  BEGIN   
                  SET   @ch=LEFT(@str,CHARINDEX(@splitchar,@str,1)-1)   
  INSERT   @temp   VALUES(@ch)   
  SET   @str=STUFF(@str,1,CHARINDEX(@splitchar,@str,1),'')   
                  END   
  RETURN   
  END
进行游标的使用和字符串的分割 
ALTER PROCEDURE [dbo].[sp_ServiceHandoverIssues_SSApply2IS2SSCheck2Pool] @TaskID INT
AS
    BEGIN
        DECLARE @error INT    
        DECLARE @temp VARCHAR(50)
        DECLARE @Gridorder INT
        DECLARE @ProjectID NVARCHAR(50)
        DECLARE @ProjectNo NVARCHAR(50)
        DECLARE @ContractNo NVARCHAR(50)
        DECLARE @RectificationDate DATETIME
        DECLARE @IssuesItem NVARCHAR(50)
        DECLARE @IsComplete NVARCHAR(50)
        DECLARE @RectificationRemark NVARCHAR(500)
  
        SET @Gridorder = 0
        SET @error = 0
    --申明游标为ContractNo
        DECLARE order_cursor CURSOR
        FOR
            SELECT  ProjectID ,
                    ProjectNo ,
                    ContractNo ,
                    RectificationDate ,
                    IssuesItem
            FROM    Form_ServiceHandover_DIssues4SSApply
            WHERE   TaskID = @TaskID
    --打开游标--
        OPEN order_cursor
    --开始循环游标变量--
        FETCH NEXT FROM order_cursor INTO @ProjectID, @ProjectNo, @ContractNo,
            @RectificationDate, @IssuesItem 
        WHILE @@FETCH_STATUS = 0    --返回被 FETCH语句执行的最后游标的状态--
            BEGIN    
			--数据目的表1安装监督反馈遗留项整改情况表Form_ServiceHandover_DIssues4IS--        
                INSERT  INTO [dbo].[Form_ServiceHandover_DIssues4IS]
                        ( TaskID ,
                          Gridorder ,
                          ProjectID ,
                          ProjectNo ,
                          ContractNo ,
                          RectificationDate ,
                          IssuesItem
                        )
                        SELECT  @TaskID ,
                                @Gridorder
                                + ( ROW_NUMBER() OVER ( ORDER BY [ID] ) ) ,
                                @ProjectID ,
                                @ProjectNo ,
                                @ContractNo ,
                                @RectificationDate ,
                                [ID]
                        FROM    dbo.fn_sys_SplitStr(@IssuesItem, ',')
                        
						--表Form_ServiceHandover_DIssues4SSCheck--
                INSERT  INTO [dbo].[Form_ServiceHandover_DIssues4SSCheck]
                        ( TaskID ,
                          Gridorder ,
                          ProjectID ,
                          ProjectNo ,
                          ContractNo ,
                          IssuesItem
                        )
                        SELECT  @TaskID ,
                                @Gridorder
                                + ( ROW_NUMBER() OVER ( ORDER BY [ID] ) ) ,
                                @ProjectID ,
                                @ProjectNo ,
                                @ContractNo ,
                                [ID]
                        FROM    dbo.fn_sys_SplitStr(@IssuesItem, ',')
						--表TB_ServiceHandover_IssuesPool--
                INSERT  INTO [dbo].[TB_ServiceHandover_IssuesPool]
                        ( ProjectID ,
                          ProjectNo ,
                          ContractNo ,
                          IssuesItem
                        )
                        SELECT  @ProjectID ,
                                @ProjectNo ,
                                @ContractNo ,
                                [ID]
                        FROM    dbo.fn_sys_SplitStr(@IssuesItem, ',')

                SELECT  @Gridorder = @Gridorder + COUNT(*)
                FROM    dbo.fn_sys_SplitStr(@IssuesItem, ',');
                SET @error = @error + @@ERROR   --记录每次运行sql后是否正确，0正确
                FETCH NEXT FROM order_cursor INTO @ProjectID, @ProjectNo,
                    @ContractNo, @RectificationDate, @IssuesItem    --转到下一个游标，没有会死循环
            END    
        CLOSE order_cursor  --关闭游标
        DEALLOCATE order_cursor   --释放游标
    END



GO