Back to OIM Explorer

dbo.QBM_FGICmp_Between_Float

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL20 lines
1CREATE FUNCTION dbo.QBM_FGICmp_Between_Float(2  @Value float,3  @lower float,4  @upper float5) RETURNS BIT6  WITH SCHEMABINDING7AS8BEGIN9  RETURN(CASE10  WHEN @lower IS NULL THEN11  012  WHEN isnull(@lower, 0.0) NOT BETWEEN 0.0 AND 1.0 THEN13  014  WHEN isnull(@upper, 0.0) NOT BETWEEN 0.0 AND 1.0 THEN15  016  WHEN isnull(@value, 0.0) >= @lower AND isnull(@value, 0.0) <= @upper THEN17  118  ELSE 019  END)20END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FGICmp_Between_Float( @Value float , @lower float , @upper float ) returns bit with SCHEMABINDING as begin return ( 2case when @lower is null then 0 when isnull(@lower, 0.0) not between 0.0 and 1.0 then 0 when isnull(@upper, 0.0) not between 0.0 and 1.0 then 0 when isnull3(@value, 0.0) >= @lower and isnull(@value, 0.0) <= @upper then 1 else 0 end ) end 4