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 vote157 views1 answer
Postgresql linux password
SQL
0 vote110 views1 answer
Java spring jdbc connect to postgresql
SQL
0 vote198 views1 answer
Postgres extract number from string
SQL
0 vote150 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote174 views1 answer
Get total and distict row diff in sql
SQL
3 votes155 views5 answers
Sql select
SQL
0 vote142 views1 answer
How to count null values in sql
SQL
7 votes244 views2 answers
Mysql default value
SQL
1 vote163 views1 answer
Nullif postgresql
SQL
0 vote105 views1 answer
Plsql trigger insert update
SQL