Back to OIM Explorer

dbo.QBM_FGIJobQueueMessageAdd

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 898 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FCVDatetimeToString source text reference
  • references source dbo.QBM_FGIUTCDate source text reference

References

Referenced By

Complete Source

SQL33 lines
1CREATE FUNCTION dbo.QBM_FGIJobQueueMessageAdd(2  @JobQueueMessageSofar nvarchar(max),3  @JobQueueMessageToAdd nvarchar(max)4) RETURNS nvarchar(max5)6AS7BEGIN8  DECLARE @MessageStringForLike nvarchar(max)9  DECLARE @erg nvarchar(max)10  DECLARE @DatetimeStamp nvarchar(max) = CONCAT('(',11  dbo.QBM_FCVDatetimeToString(dbo.QBM_FGIUTCDate()),12  ') ')13  SELECT @MessageStringForLike = replace(14  RIGHT(@JobQueueMessageToAdd, 150),15  '[',16  '[[]')17  SELECT18    @MessageStringForLike = CONCAT(N '%',19    replace(replace(@MessageStringForLike, '%', '[%]'), '_', '[_]'))20  SELECT @erg = CASE21  WHEN @JobQueueMessageSofar > ' ' AND @JobQueueMessageSofar NOT LIKE @MessageStringForLike THEN22  CONCAT(@JobQueueMessageSofar,23  nchar(13),24  nchar(10),25  @DatetimeStamp,26  @JobQueueMessageToAdd)27  WHEN @JobQueueMessageSofar > ' ' THEN28  @JobQueueMessageSofar29  ELSE CONCAT(@DatetimeStamp,30  @JobQueueMessageToAdd)31  END32  RETURN(@erg)33END
Open raw exported source
SQL ยท Raw7 lines
1  create   function dbo.QBM_FGIJobQueueMessageAdd(@JobQueueMessageSofar nvarchar(max) , @JobQueueMessageToAdd nvarchar(max) ) returns nvarchar(max2) as begin declare @MessageStringForLike nvarchar(max) declare @erg nvarchar(max) declare @DatetimeStamp nvarchar(max) = concat( '(' , dbo.QBM_FCVDatetimeToString3(dbo.QBM_FGIUTCDate()) , ') ' )  select @MessageStringForLike = replace(right(@JobQueueMessageToAdd, 150) , '[', '[[]') select @MessageStringForLike = 4concat( N'%' , replace(replace(@MessageStringForLike , '%', '[%]') , '_', '[_]') ) select @erg = case when @JobQueueMessageSofar > ' ' and @JobQueueMessageSofar5 not like @MessageStringForLike  then concat(@JobQueueMessageSofar , nchar(13) , nchar(10) , @DatetimeStamp , @JobQueueMessageToAdd) when @JobQueueMessageSofar6 > ' ' then @JobQueueMessageSofar  else concat(@DatetimeStamp , @JobQueueMessageToAdd) end return(@erg) end 7