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 vote327 views1 answer
Search db for table name
SQL
2 votes358 views1 answer
Oracle run_duration average
SQL
1 vote351 views2 answers
Postgres copy table from one schema to another
SQL
-1 vote407 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote344 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote354 views1 answer
Sql server check whether column has same equal values
SQL
0 vote350 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote346 views2 answers
Wordpress change url in database
SQL
1 vote328 views1 answer
Increase date by one day in sql oracle
SQL
0 vote362 views1 answer
Oracle sql copy table without data
SQL