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 vote173 views1 answer
Plpgsql if statement
SQL
0 vote175 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote190 views3 answers
Java hide mysql login credentials
SQL
1 vote193 views2 answers
Check if word is in column sql
SQL
0 vote206 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
65 votes304 views6 answers
Sql add column to table
SQL
2 votes212 views2 answers
Mysql does sentence contain word
SQL
0 vote171 views1 answer
Select top 3 sql
SQL
0 vote168 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote208 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL