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

0 vote193 views1 answer
Mysql date only no time
SQL
0 vote256 views1 answer
Mysql get longest string in column
SQL
0 vote190 views1 answer
How to get employee having maximum experience in mysql
SQL
2 votes196 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote204 views2 answers
Create row number in sql
SQL
2 votes191 views1 answer
Oracle drop sequence if exists
SQL
1 vote189 views1 answer
Psql connections
SQL
0 vote200 views1 answer
Create a plsql object
SQL
4 votes192 views1 answer
Mysql set max connections
SQL
0 vote214 views2 answers
While mysql
SQL