dbo.QBM_FGISessionErrorIsDeadlock

1     create   function dbo.QBM_FGISessionErrorIsDeadlock (@ErrorBuffer QBM_YSessionError readOnly  ) returns int  as begin declare @erg bit = 0 
2declare @CursorString nvarchar(64) = N'cur' + N'sor' declare @BufferIntern QBM_YSessionError declare @LastElement int if not exists (select top 1 1 from
3 @ErrorBuffer ) begin insert into @BufferIntern(ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID
4, RepeatCounter, IsReThrow, SourceCode) select ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID
5, RepeatCounter, IsReThrow, SourceCode from dbo.QBM_FTSessionErrorLoad() l  order by l.RecordNumber end else begin insert into @BufferIntern(ErrorMessage
6, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode) select ErrorMessage
7, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode from @ErrorBuffer
8 end select @LastElement = MAX(b.ElementIndex) from @BufferIntern b where b.IsReThrow = 0 if exists (select top 1 1 from @BufferIntern b where b.ElementIndex
9 = @LastElement and (b.ErrorNumber in (1205  , 16943  , 1222  , 2021  , 601  , 2791  ) or b.ErrorMessage like '%Transaction%was deadlocked%deadlock victim%'
10  or b.ErrorMessage like '%Lock request%exceeded%' or b.ErrorMessage like '%The referenced entity%was modified during DDL execution%' or b.ErrorMessage
11 like '%Could not continue scan with NOLOCK due to data movement%' or b.ErrorMessage like '%Could not resolve expression for Schema-bound object or constraint%'
12 or b.ErrorMessage like '%No success after all retries%' or b.ErrorMessage like '%See previous errors%' ) ) begin select @erg = 1 end endLabel: return(@erg
13) end 
14