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 vote196 views1 answer
Postgresql like
SQL
0 vote190 views1 answer
SQL server select to get sum of hours
SQL
0 vote266 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote167 views1 answer
Copy table dbeaver
SQL
1 vote196 views1 answer
Xampp import sql file command line
SQL
0 vote199 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
2 votes288 views2 answers
Null column to 0 in mysql
SQL
13 votes212 views3 answers
Uninstall mysql centos 7
SQL
1 vote165 views1 answer
Postgresql last element of array
SQL
0 vote250 views1 answer
Selecting from a view SQL
SQL