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

3 votes130 views1 answer
Sql select second max
SQL
1 vote93 views2 answers
T sql get foreign key
SQL
49 votes167 views6 answers
Alter table add column
SQL
0 vote106 views1 answer
Hibernate show sql xml property
SQL
0 vote95 views2 answers
Add new column after in sql
SQL
1 vote108 views1 answer
Sql find column name like
SQL
0 vote139 views1 answer
Multiple like values for single column postgres
SQL
0 vote101 views2 answers
Update all linkedserver tables with openquery on db
SQL
1 vote118 views1 answer
Sql first day quarter
SQL
0 vote109 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL