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 vote342 views1 answer
C# get sql min date
SQL
0 vote355 views1 answer
Python sql last insertend
SQL
2 votes313 views2 answers
Mysql get time from datetime
SQL
0 vote298 views10 answers
John the ripper mysql
SQL
0 vote305 views1 answer
Raiserror nowait sql server
SQL
1 vote317 views1 answer
Postgres delete from where date is greater than specific date
SQL
0 vote348 views1 answer
Count columns psql(PostreSQL)
SQL
6 votes324 views4 answers
How to remove unique key in mysql
SQL
1 vote341 views1 answer
Round function in sql oracle
SQL
2 votes346 views2 answers
Mysql count rows returned
SQL