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 vote119 views1 answer
View acl table oracle
SQL
3 votes151 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
6 votes117 views1 answer
Wordpress change user password sql
SQL
2 votes121 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
1 vote133 views1 answer
Calculate age in sql postgresql
SQL
4 votes146 views3 answers
NOT NULL SQL
SQL
6 votes135 views1 answer
Allsource oracle
SQL
1 vote121 views1 answer
Mysql login console
SQL
6 votes132 views2 answers
Foreign key sqlite3 python
SQL
0 vote138 views1 answer
Sql query to find duplicate email address
SQL