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

1 vote163 views1 answer
Lpad function in sql oracle
SQL
1 vote133 views1 answer
Round function in sql oracle
SQL
1 vote169 views1 answer
Sql order by timestamp
SQL
0 vote183 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote142 views1 answer
Oracle drop default value
SQL
0 vote217 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote136 views1 answer
User defined variables in sql
SQL
2 votes143 views1 answer
Date_format for time sql
SQL
8 votes135 views5 answers
Grant permission in postgres
SQL
0 vote143 views1 answer
Mysql milliseconds
SQL