Back to OIM Explorer

dbo.QBM_FSQRemoveCommentAndFormatX

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 533 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_FCVStringToList source text reference
  • references source dbo.QBM_FCVStringToListSQLMorphem source text reference
  • references source dbo.QBM_FCVStringToListSQLMorphem0 source text reference
  • references source dbo.QBM_FSQRemoveComment source text reference
  • references source dbo.QBM_FSQRemoveCommentAndFormat source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL22 lines
1CREATE FUNCTION dbo.QBM_FSQRemoveCommentAndFormatX(2  @SQLIn nvarchar(max)3) RETURNS nvarchar(max4)5AS6BEGIN7  RETURN(8  SELECT9    string_agg(convert(nvarchar(max), z.zeile), nchar(13) + nchar(10)) within10    GROUP(11  ORDER BY z.targetline)12  FROM(13  SELECT14    x.targetLine, string_agg(convert(nvarchar(max), x.Morphem), N ' ') within15    GROUP(16  ORDER BY x.Sortorder) AS zeile17  FROM(18  SELECT19    z.SortOrder, LenMorphem, TargetLine, z.Morphem20  FROM dbo.QBM_FCVStringToListSQLMorphem0(@SQLIn, 0, 0) z) AS x21  GROUP BY x.TargetLine) AS z)22END
Open raw exported source
SQL ยท Raw5 lines
1   create   function dbo.QBM_FSQRemoveCommentAndFormatX (@SQLIn nvarchar(max) ) returns nvarchar(max) as begin return( select string_agg(convert2(nvarchar(max),z.zeile )  , nchar(13) + nchar(10) )  within group (order by z.targetline) from ( select x.targetLine, string_agg(convert(nvarchar(max),3 x.Morphem )  , N' ' )  within group (order by x.Sortorder) as zeile from ( select z.SortOrder, LenMorphem, TargetLine, z.Morphem from dbo.QBM_FCVStringToListSQLMorphem04 (@SQLIn, 0, 0) z  ) as x Group by x.TargetLine ) as z ) end 5