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

10 votes138 views2 answers
Mysql drop database if exists
SQL
1 vote129 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote131 views1 answer
Compare subqueries oracle
SQL
8 votes133 views1 answer
Oracle current date plus 1 month
SQL
2 votes121 views1 answer
Oracle calculated column
SQL
1 vote139 views1 answer
Oracle enable job
SQL
3 votes201 views1 answer
Sql add two values together
SQL
2 votes165 views1 answer
Oracle log files
SQL
0 vote138 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote162 views2 answers
Insert data into multiple tables mysql
SQL