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

1 vote138 views1 answer
Mariadb alter user host
SQL
0 vote131 views1 answer
Mysql match in serialized data
SQL
0 vote94 views1 answer
Sql count how many times a value appears
SQL
1 vote122 views1 answer
Table infromation in sql server
SQL
0 vote89 views1 answer
Ms sql print more than 1 variable
SQL
0 vote220 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote136 views1 answer
Flask sqlalchemy decimal
SQL
2 votes140 views1 answer
Get hour from date sql
SQL
3 votes137 views2 answers
Mysql create timestamp column
SQL
1 vote137 views1 answer
Oracle list datafiles in tablespace
SQL