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 vote352 views1 answer
Php select data from mysql database without column name
SQL
1 vote354 views2 answers
How to add amount between date in sql
SQL
2 votes342 views1 answer
Postgresql transaction
SQL
2 votes364 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote340 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote338 views1 answer
Char vs varchar2 in sql
SQL
1 vote395 views2 answers
Mysql limit offset
SQL
0 vote370 views3 answers
Postgres date difference seconds
SQL
0 vote351 views1 answer
How convert into in in sql query
SQL
49 votes431 views6 answers
Mysql add column to table
SQL