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 vote279 views1 answer
Mysql error codeigniter
SQL
6 votes296 views2 answers
Where clause in sql
SQL
0 vote299 views1 answer
Sql server concat null
SQL
0 vote344 views1 answer
Postgres docs /copy metacomand
SQL
1 vote314 views1 answer
Pl sql create table from another table
SQL
1 vote297 views1 answer
SQLite order random
SQL
2 votes327 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote333 views1 answer
How to find date from date table in sql
SQL
-1 vote288 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
-1 vote316 views2 answers
Installing mysql on centos 7
SQL