Back to OIM Explorer

dbo.QBM_FGIString_Split_Ordinal

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL24 lines
1CREATE FUNCTION dbo.QBM_FGIString_Split_Ordinal(2  @in varchar(max),3  @Separator varchar(1),4  @Ordinal int5) RETURNS varchar(2556)7  WITH schemabinding8AS9BEGIN10  DECLARE @Erg varchar(255) = NULL11  DECLARE @Tab TABLE(Element varchar(256) collate database_default,12  Ordinal int identity)13  INSERT INTO @Tab(Element)14  SELECT15  LEFT(v.value,16  256)17  FROM string_split(@in,18  @Separator) v19  SELECT TOP 1 @Erg = t.Element20  FROM @Tab t21  WHERE22    t.Ordinal = @Ordinal23  RETURN(@erg)24END
Open raw exported source
SQL ยท Raw5 lines
1          create   function dbo.QBM_FGIString_Split_Ordinal(@in varchar(max) , @Separator varchar(1) , @Ordinal int  ) returns varchar(255) with2 schemabinding as begin declare @Erg varchar(255) = null declare @Tab table (Element varchar(256) collate database_default , Ordinal int identity ) insert3 into @Tab (Element) select left(v.value, 256) from string_split(@in, @Separator) v select top 1 @Erg = t.Element from @Tab t where t.Ordinal = @Ordinal4 return(@erg) end 5