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 vote155 views1 answer
Mysql query problems and solutions
SQL
3 votes186 views5 answers
Duplicate table sql
SQL
5 votes161 views4 answers
Mysql update column with value from another table
SQL
0 vote151 views1 answer
Sum value by month sql
SQL
4 votes150 views1 answer
Oracle delete last row
SQL
0 vote156 views1 answer
Jdbc sql connection string
SQL
0 vote133 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote294 views2 answers
Create new table from existing table with data in sql server
SQL
0 vote157 views1 answer
Drop view in mysql
SQL
1 vote150 views1 answer
Rails run native ssql query
SQL