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 vote179 views3 answers
How to get date in sql
SQL
0 vote182 views3 answers
Postgresql allow remote connections
SQL
0 vote179 views1 answer
Postgresql in vs any performance
SQL
9 votes176 views4 answers
How to alter table column name in mysql
SQL
14 votes182 views2 answers
Oracle add attribute to table
SQL
0 vote167 views2 answers
Sqlite
SQL
3 votes178 views2 answers
Postgres show table schema
SQL
3 votes206 views1 answer
Sql double index
SQL
0 vote181 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote173 views1 answer
Fast sql column count
SQL