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 vote195 views1 answer
Oracle string length
SQL
0 vote186 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote178 views1 answer
Selects all the columns from the sailors table
SQL
3 votes186 views1 answer
Insert into table from another table mysql
SQL
0 vote209 views1 answer
Oracle decode
SQL
4 votes142 views1 answer
Oracle sleep
SQL
1 vote184 views1 answer
Sysdate in sql
SQL
0 vote175 views1 answer
Raiserror nowait sql server
SQL
0 vote192 views1 answer
Get id if is not equal in certain table
SQL
1 vote282 views1 answer
Sql server delete top 1000
SQL