主题：游标循环出错时如何跳到下一个值继续执行?

参考

 
begin
    DECLARE @names NVARCHAR(MAX);
    DECLARE @name VARCHAR(40);
    DECLARE @result int;
     SET @names = '';
     
    DECLARE MyCursor CURSOR
    FOR
        SELECT  name
        FROM    dbo.sysobjects
        WHERE   OBJECTPROPERTY(id, N'IsView') = 1
                AND ( NOT name IN ( 'sysconstraints', 'syssegments' )
                    );
    OPEN MyCursor;
    FETCH NEXT FROM MyCursor
    INTO @name;
    WHILE ( @@fetch_status <> -1 )
        BEGIN
            IF ( @@fetch_status <> -2 )
                BEGIN
                   BEGIN TRY
                       EXEC sp_refreshview @name;
                    END TRY
                    BEGIN CATCH
                        SET @names = @names + ',' + @name --记录出错的视图
                        ROLLBACK;
                        FETCH NEXT FROM MyCursor INTO @name;
                    END CATCH;
                END;
            FETCH NEXT FROM MyCursor
        INTO @name;
        END;
    CLOSE MyCursor;
    DEALLOCATE MyCursor;
    PRINT @names;
end