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 vote314 views3 answers
Mysql CAST(amount as float)
SQL
0 vote262 views1 answer
Sql counter column
SQL
0 vote258 views1 answer
Multiple tricky query in sql server
SQL
1 vote284 views4 answers
Get week day from date in sql
SQL
0 vote263 views1 answer
Sum values by month mariadb
SQL
0 vote282 views2 answers
Greater than sql server
SQL
0 vote263 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote278 views1 answer
Change filed order in mysql
SQL
9 votes251 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
2 votes309 views1 answer
Postgresql group by month and year
SQL