Back to OIM Explorer

dbo.QBM_FGICmp_GT_Empty

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 195 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.QBM_FGICmp_GT_Empty(2  @Value varchar(138)3) RETURNS BIT4  WITH SCHEMABINDING5AS6BEGIN7  RETURN(CASE8  WHEN @value IS NULL THEN9  010  WHEN @Value > ' ' THEN11  112  ELSE 013  END)14END
Open raw exported source
SQL · Raw3 lines
1   create   function dbo.QBM_FGICmp_GT_Empty( @Value varchar(138) ) returns bit with SCHEMABINDING as begin return ( case when @value is null then2 0 when @Value > ' ' then 1 else 0 end ) end 3