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

-1 vote258 views1 answer
Mac mysql workbench console
SQL
0 vote259 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote242 views1 answer
Postgresql regular expression special characters
SQL
0 vote255 views1 answer
Except in sql
SQL
0 vote268 views1 answer
Sql server change schema of a table
SQL
0 vote267 views1 answer
Oracle change password expiration policy
SQL
0 vote214 views1 answer
Calculate discount from original price sql
SQL
2 votes249 views1 answer
Oracle table size
SQL
0 vote284 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote246 views1 answer
Default column value in sql same as other column
SQL