Back to OIM Explorer

dbo.QBM_FCVStringToListSplitted

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 429 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_FCVStringToList_i source text reference

Complete Source

SQL15 lines
1CREATE FUNCTION dbo.QBM_FCVStringToListSplitted(2  @InString nvarchar(max),3  @Delimiter nvarchar(64),4  @SuppressEmpty BIT = 0,5  @CaseSensitive BIT = 0,6  @DelimiterInRow nvarchar(1)7) RETURNS TABLE8AS9RETURN(10SELECT11  x.OrderNumber,12  x.Parameter1 AS ParameterName,13  x.Parameter2 AS ParameterValue,14  x.OrderNumberReverse15FROM dbo.QBM_FCVStringToList_i(@InString, @Delimiter, @SuppressEmpty, @CaseSensitive, @DelimiterInRow) x)
Open raw exported source
SQL ยท Raw4 lines
1create function dbo.QBM_FCVStringToListSplitted(@InString nvarchar(max) , @Delimiter nvarchar(64) , @SuppressEmpty bit = 0 , @CaseSensitive bit = 0 , @DelimiterInRow2 nvarchar(1) )     returns table as  return( select x.OrderNumber, x.Parameter1 as ParameterName, x.Parameter2 as ParameterValue, x.OrderNumberReverse 3from dbo.QBM_FCVStringToList_i(@InString, @Delimiter, @SuppressEmpty, @CaseSensitive, @DelimiterInRow) x ) 4