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

36 votes201 views6 answers
Rename table sql
SQL
13 votes199 views3 answers
Insert mysql ifile nto database
SQL
1 vote185 views1 answer
Find logged in users mysql
SQL
1 vote200 views1 answer
Vagrant mysql downgrade version
SQL
0 vote185 views3 answers
Average salary in sql
SQL
3 votes205 views1 answer
Oracle apex message quit website
SQL
4 votes145 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
5 votes219 views1 answer
Mysql count newlines in field
SQL
4 votes180 views1 answer
Sql group by year
SQL
4 votes196 views2 answers
Oracle default date format
SQL