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 vote124 views1 answer
Get who is hired in february in sql
SQL
0 vote120 views1 answer
Oracle exchange partition
SQL
1 vote135 views1 answer
Connect to mysql database ubuntu
SQL
14 votes131 views3 answers
Inner join sql oracle
SQL
0 vote126 views2 answers
Nodejs mysql convert to plain object
SQL
-1 vote116 views1 answer
Su: Authentication failure mysql
SQL
0 vote123 views1 answer
Zsh: command not found: mysql mamp
SQL
-2 votes121 views1 answer
No module named '_sqlite3
SQL
3 votes125 views1 answer
Mysql replace string in table
SQL
0 vote137 views1 answer
Sqlite3 pragma foreign keys
SQL