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 vote306 views1 answer
Postgresql log
SQL
0 vote326 views1 answer
Create table database in psql
SQL
1 vote310 views2 answers
Select only columns that are not empty oracle sql
SQL
1 vote325 views1 answer
Retrieve meaning
SQL
0 vote322 views1 answer
Migrations.RunSQL
SQL
1 vote312 views2 answers
Last working day in week date function in sql
SQL
0 vote301 views1 answer
Oracle search in date columns
SQL
5 votes329 views2 answers
Postgresql insert select
SQL
1 vote336 views1 answer
Oracle sql first day of year
SQL
0 vote312 views1 answer
Python mysqlclient library not found for -lssl
SQL