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

15 votes229 views4 answers
Mysql where value is null
SQL
0 vote252 views3 answers
Select top 10 rows in sql
SQL
0 vote218 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
1 vote233 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote218 views1 answer
What is intersect
SQL
36 votes236 views6 answers
Delete from where sql
SQL
0 vote235 views3 answers
Delete in SQL SERVER
SQL
1 vote225 views1 answer
How to put value in variable mysql
SQL
0 vote201 views1 answer
Oracle activate program
SQL
0 vote211 views1 answer
Sql auto_increment syntax
SQL