Back to OIM Explorer

dbo.QBM_FTString_Split_Ordinal

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

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

SQL17 lines
1CREATE FUNCTION dbo.QBM_FTString_Split_Ordinal(2  @in varchar(max),3  @Separator varchar(1)4) RETURNS @erg TABLE(Value varchar(256) collate database_default,5Ordinal int identity6)7  WITH SCHEMABINDING8AS9BEGIN10  INSERT INTO @Erg(Value)11  SELECT12  LEFT(v.value,13  256)14  FROM string_split(@in,15  @Separator) v16  RETURN17END
Open raw exported source
SQL ยท Raw4 lines
1create function dbo.QBM_FTString_Split_Ordinal(@in varchar(max) , @Separator varchar(1) ) returns @erg table (Value varchar(256) collate database_default2 , Ordinal int identity ) with SCHEMABINDING as begin insert into @Erg (Value) select left(v.value, 256) from string_split(@in, @Separator) v return end3 4