Breaking News: Grepper is joining You.com. Read the official announcement!

T-SQL Retry (deadlock)

Important Impala answered on January 31, 2022 Popularity 1/10 Helpfulness 1/10

answer T-SQL Retry (deadlock)

T-SQL Retry (deadlock)

Comment

Declare @Counterloop int =0, @IsSuccess int = 0
 
while (@Counterloop <=3 and @IsSuccess = 0)
Begin
    Begin Try
 
        --Piece of code for Retry/Re-Execution - START--
        select 1/0
        ---EXEC Rexcute_Retry_SP
        --Piece of code for Retry/Re-Execution - END--
 
        set @IsSuccess=1
 
    END TRY
    BEGIN Catch
        IF (@Counterloop<=2) Begin
            set @Counterloop=@Counterloop+1
            print 'counter value is'+ cast(@Counterloop as varchar)
        END
        ELSE Throw;
    END Catch
END

Popularity 1/10 Helpfulness 1/10 Language sql

Source: sqlzealots.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Jan 31 2022

Important Impala

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

T-SQL Retry (deadlock)

Contents

More Related Answers

T-SQL Retry (deadlock)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.