Back to OIM Explorer

dbo.QBM_FCVStringToJobParameter

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL13 lines
1CREATE FUNCTION dbo.QBM_FCVStringToJobParameter(2  @inparm nvarchar(max)3) RETURNS nvarchar(max4)5  WITH SCHEMABINDING6AS7BEGIN8  RETURN(CASE9  WHEN @inparm > N ' ' THEN10  CONCAT(convert(nvarchar(32), len(rtrim(@inparm))), N '~', rtrim(@inparm), N '~')11  ELSE N '0~~'12  END)13END
Open raw exported source
SQL ยท Raw3 lines
1   create   function dbo.QBM_FCVStringToJobParameter (@inparm nvarchar(max)) returns nvarchar(max) with SCHEMABINDING as begin return( case when2 @inparm > N' ' then concat(convert(nvarchar(32), len(rtrim(@inparm)) ) , N'~' , rtrim(@inparm) , N'~' ) else N'0~~' end ) end 3