T-SQL Retry (deadlock)

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

Source: sqlzealots.com

Similar codes

2 votes266 views1 answer
Update trigger
SQL
0 vote276 views1 answer
Query params sql insert python f string
SQL
1 vote269 views1 answer
Oracle rolling back
SQL
0 vote269 views2 answers
Mysql regexp match word
SQL
16 votes315 views1 answer
Sqlserver add column to table
SQL
0 vote269 views1 answer
Cast as decimal postgresql
SQL
1 vote279 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote266 views1 answer
Sql server cannot create database diagram
SQL
5 votes288 views4 answers
Restart the psql server windows
SQL
0 vote271 views1 answer
How to create a table in sql stack overflow
SQL