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 vote158 views3 answers
Insert query in ci
SQL
0 vote141 views1 answer
Sql server select ignore dupplicates
SQL
0 vote142 views1 answer
Mysql 8 geo to json
SQL
79 votes326 views6 answers
Grepper code
SQL
1 vote149 views1 answer
Postgresql create table with timestamp
SQL
0 vote139 views1 answer
Alasql delete column
SQL
0 vote141 views1 answer
Code to move ietms from one table to another myswl
SQL
1 vote127 views1 answer
Error code 1175 mysql fix
SQL
4 votes149 views1 answer
Sql data types
SQL
0 vote142 views1 answer
Version and edition of SQL Server Database Engine
SQL