Back to OIM Explorer

dbo.QBM_FGICmp_Contains

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL45 lines
1CREATE FUNCTION dbo.QBM_FGICmp_Contains(2  @Value nvarchar(max),3  @Item nvarchar(64)4) RETURNS BIT5  WITH SCHEMABINDING6AS7BEGIN8  RETURN(CASE9  WHEN @value IS NULL THEN10  011  WHEN @item IS NULL THEN12  013  WHEN @Item IN('Unified', 'DynamicMembership') THEN14  CASE15    WHEN @Value LIKE CONCAT(N '%', @Item, N '%') THEN16  117  ELSE 018  END19  WHEN @Item = 'Overrides' THEN20  CASE21    WHEN @Value LIKE '% Overrides %' THEN22  123  ELSE 024  END25  WHEN @Item = 'Overridable' THEN26  CASE27    WHEN @Value LIKE '% Overridable %' THEN28  129  ELSE 030  END31  WHEN @Item = '#EXT#' THEN32  CASE33    WHEN @Value LIKE '%#EXT#%' THEN34  135  ELSE 036  END37  WHEN @Item = 'SecurityEnabled' THEN38  CASE39    WHEN @Value LIKE '%SecurityEnabled%' THEN40  141  ELSE 042  END43  ELSE 044  END)45END
Open raw exported source
SQL ยท Raw6 lines
1    create   function dbo.QBM_FGICmp_Contains( @Value nvarchar(max) , @Item nvarchar(64) ) returns bit with SCHEMABINDING as begin return (case 2 when @value is null then 0 when @item is null then 0   when @Item in( 'Unified' , 'DynamicMembership' ) then case when @Value like concat(N'%', @Item,3 N'%') then 1 else 0 end when @Item = 'Overrides' then case when @Value like '% Overrides %' then 1 else 0 end when @Item = 'Overridable' then case when4 @Value like '% Overridable %' then 1 else 0 end  when @Item = '#EXT#' then case when @Value like '%#EXT#%' then 1 else 0 end when @Item = 'SecurityEnabled'5 then case when @Value like '%SecurityEnabled%' then 1 else 0 end else 0 end ) end 6