Back to OIM Explorer

dbo.QBM_FCVParameter1AsOneInClause

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL16 lines
1CREATE FUNCTION dbo.QBM_FCVParameter1AsOneInClause(2  @ValuesIn dbo.QBM_YParameterList READONLY3) RETURNS nvarchar(max4)5  WITH SCHEMABINDING6AS7BEGIN8  RETURN(9  SELECT10    CONCAT(N '(''', string_agg(convert(nvarchar(max), CASE11    WHEN c.Parameter1 LIKE '%''%' THEN12    replace(c.Parameter1, '''', '''''')13  ELSE c.Parameter114  END), N ''','''), N ''')')15  FROM @ValuesIn c)16END
Open raw exported source
SQL ยท Raw4 lines
1    create   function dbo.QBM_FCVParameter1AsOneInClause (@ValuesIn dbo.QBM_YParameterList readOnly ) returns nvarchar(max) with SCHEMABINDING as2 begin return( select concat(N'(''' ,string_agg(convert(nvarchar(max), case when c.Parameter1 like '%''%' then replace(c.Parameter1, '''', '''''') else3 c.Parameter1 end )  , N''',''' )  , N''')' ) from @ValuesIn c ) end 4