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 vote158 views1 answer
Influxdb list all tags for a measurement
SQL
3 votes128 views2 answers
Sql paging query
SQL
2 votes140 views3 answers
Copy data from one table column to another table column in sql
SQL
-1 vote137 views1 answer
How to create foreign key in sql server management studio
SQL
5 votes125 views1 answer
Sysdate in oracle sql
SQL
1 vote132 views1 answer
Adding a default constraint to an existing column in sql
SQL
4 votes140 views1 answer
Refresh postgres config
SQL
0 vote149 views1 answer
Psql no such file or directory
SQL
1 vote137 views1 answer
Create new table from old table
SQL
2 votes127 views1 answer
Mysql increment value by 1 in update
SQL