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

9 votes176 views4 answers
How to remove duplicate in sql
SQL
6 votes190 views2 answers
Where clause in sql
SQL
1 vote200 views1 answer
Sql select max value from multiple rows
SQL
0 vote191 views2 answers
Replace null with 0 in sql
SQL
3 votes180 views1 answer
Oracle list user grants
SQL
-1 vote217 views2 answers
Sql truncate number
SQL
0 vote193 views1 answer
Kill slow queries mysql
SQL
1 vote221 views1 answer
Mysql select update same table
SQL
0 vote196 views1 answer
Sp in sql server
SQL
0 vote182 views1 answer
Doesn't have default value mysql
SQL