Back to OIM Explorer

dbo.QBM_FGICmp_DateDiff_DD_LE

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL17 lines
1CREATE FUNCTION dbo.QBM_FGICmp_DateDiff_DD_LE(2  @Value datetime,3  @diff int4) RETURNS BIT5  WITH SCHEMABINDING6AS7BEGIN8  RETURN(CASE9  WHEN @Value IS NULL THEN10  011  WHEN @diff IS NULL THEN12  013  WHEN DateDiff(dd, @Value, GetUTCDate()) <= @diff THEN14  115  ELSE 016  END)17END
Open raw exported source
SQL ยท Raw3 lines
1  create   function dbo.QBM_FGICmp_DateDiff_DD_LE( @Value datetime , @diff int ) returns bit with SCHEMABINDING as begin return ( case when @Value2 is null then 0 when @diff is null then 0 when DateDiff(dd, @Value, GetUTCDate()) <= @diff then 1 else 0 end ) end 3