Back to OIM Explorer

dbo.QBM_FGIJobCreateName

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 410 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL24 lines
1CREATE FUNCTION dbo.QBM_FGIJobCreateName(2  @AddOn nvarchar(356)3) RETURNS nvarchar(2564)5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @Vorspann nvarchar(64) = 'Created by QBMDBQueueProcess'9  DECLARE @erg nvarchar(256)10  IF @AddOn > ' '11  BEGIN12    SELECT @erg = @AddOn13  END14  ELSE15  BEGIN16    SELECT @erg = @Vorspann17  END18  IF @erg NOT LIKE @Vorspann + '%'19  BEGIN20    SELECT @erg = @Vorspann + ':' + @erg21  END22  endLabel:23  RETURN(@erg)24END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FGIJobCreateName (@AddOn nvarchar(356) ) returns nvarchar(256) with SCHEMABINDING as begin declare @Vorspann nvarchar2(64) = 'Created by QBMDBQueueProcess' declare @erg nvarchar(256)  if @AddOn > ' ' begin select @erg = @AddOn end else begin select @erg = @Vorspann end3 if @erg not like @Vorspann + '%' begin select @erg = @Vorspann + ':' + @erg end endLabel: return(@erg) end 4