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

7 votes158 views2 answers
Get database size mysql
SQL
0 vote157 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote181 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote151 views1 answer
Acual month sql
SQL
1 vote164 views1 answer
Altrer name column postgres
SQL
0 vote148 views1 answer
Cast for print sql
SQL
7 votes150 views3 answers
Postgresql dump and restore db
SQL
0 vote169 views1 answer
What is top n result in sql
SQL
7 votes167 views3 answers
Foreign key oracle
SQL
6 votes147 views1 answer
Wordpress change user password sql
SQL