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 vote282 views1 answer
Select into table variable
SQL
1 vote288 views1 answer
How to delete data from sql database in android
SQL
9 votes280 views1 answer
Sql server get utc date
SQL
0 vote265 views1 answer
Mysql_num_fields in mysqli
SQL
6 votes274 views2 answers
Mysql version check cmd
SQL
2 votes276 views2 answers
How to view created temporary tables in mysql
SQL
1 vote278 views3 answers
How to truncate foreign key constraint table
SQL
0 vote295 views1 answer
Sql get year from datetime field
SQL
0 vote288 views1 answer
Sql get highest date from 3 tabels
SQL
2 votes308 views2 answers
Oracle create table if not exists
SQL