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

7 votes353 views1 answer
Set sequence value oracle
SQL
1 vote363 views1 answer
How to change owner in postgres
SQL
27 votes379 views5 answers
Mysql set password for user
SQL
0 vote359 views1 answer
No suitable driver found for sqlite
SQL
7 votes383 views3 answers
Add primary key to database sql
SQL
0 vote359 views1 answer
Create table as select sql server error
SQL
0 vote354 views1 answer
Install package for sqlserver in asp.net core
SQL
2 votes392 views1 answer
Mysql id of inserted row
SQL
9 votes378 views4 answers
How to alter table column name in mysql
SQL
0 vote356 views1 answer
How to open mysql in docker
SQL