Back to OIM Explorer

dbo.QBM_FCVJobParameterName

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 437 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

  • No direct source references extracted.

Complete Source

SQL32 lines
1CREATE FUNCTION dbo.QBM_FCVJobParameterName(2  @wert nvarchar(max)3) RETURNS nvarchar(max4)5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @erg nvarchar(max)9  IF isnull(@wert,10  N '') = N ''11  BEGIN12    SELECT @erg = N ''13    RETURN(@erg)14  END15  IF16  LEFT(@wert,17  1) = N '_'18  BEGIN19    SELECT @erg = @wert20  END21  ELSE22  BEGIN23    SELECT @erg = N 'val_' + @wert24  END25  IF @wert IN(N 'ConnectionVariables',26  N 'SingleTransaction')27  BEGIN28    SELECT @erg = @wert29  END30  ende:31  RETURN(@erg)32END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FCVJobParameterName (@wert nvarchar(max) ) returns nvarchar(max) with SCHEMABINDING as begin declare @erg nvarchar(max2) if isnull(@wert,N'') = N'' begin select @erg = N''  return(@erg)  end if left(@wert,1) = N'_' begin  select @erg = @wert end else begin select @erg =3 N'val_' + @wert end  if @wert in( N'ConnectionVariables', N'SingleTransaction') begin select @erg = @wert end ende: return(@erg) end 4