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

4 votes309 views2 answers
DB::transaction
SQL
1 vote322 views1 answer
Pl sql ptint
SQL
0 vote339 views1 answer
Sql file in postgres with pgadmin
SQL
1 vote318 views1 answer
Mysql f# examples
SQL
1 vote339 views1 answer
Is sql fast
SQL
21 votes319 views3 answers
Average sql
SQL
2 votes328 views1 answer
Oracle calculated column
SQL
0 vote309 views1 answer
Oracle execute immediate quotes
SQL
2 votes325 views2 answers
Get all columns from table sql
SQL
0 vote319 views1 answer
Get record which is available in one table but not in another mysql
SQL