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 vote239 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote216 views1 answer
Oracle right characters
SQL
2 votes233 views1 answer
Mysql create user with mysql_native_password
SQL
1 vote232 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
4 votes232 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote241 views1 answer
Sql pivot table
SQL
1 vote253 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote231 views1 answer
Geopoint from json mysql function
SQL
0 vote233 views1 answer
How to print sql query
SQL
0 vote243 views1 answer
Drop-toys-table
SQL