Back to OIM Explorer

dbo.QER_FGICmp_OrgRoot_EQ_Org

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL14 lines
1CREATE FUNCTION dbo.QER_FGICmp_OrgRoot_EQ_Org(2  @Value varchar(38)3) RETURNS BIT4  WITH SCHEMABINDING5AS6BEGIN7  RETURN(CASE8  WHEN @Value IS NULL THEN9  010  WHEN @Value LIKE '____[^V]%' THEN11  112  ELSE 013  END)14END
Open raw exported source
SQL ยท Raw3 lines
1 create   function dbo.QER_FGICmp_OrgRoot_EQ_Org( @Value varchar(38) ) returns bit with SCHEMABINDING as begin return ( case when @Value is null2 then 0 when @Value like '____[^V]%' then 1 else 0 end ) end 3