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 vote313 views1 answer
Oracle sql developer closed connection
SQL
2 votes248 views1 answer
Latest record in sql
SQL
2 votes287 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote281 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote300 views1 answer
Laravel migration sql dump
SQL
5 votes282 views1 answer
Sql use database
SQL
0 vote303 views1 answer
Full outer join in mariadb mysql
SQL
7 votes290 views5 answers
Show details of table postgres
SQL
5 votes314 views3 answers
Sql server utc to local
SQL
5 votes300 views1 answer
Dbms_metadata.get_ddl table
SQL