Back to OIM Explorer

dbo.QBM_FGIXOriginChanged_Effect

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 316 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.

Complete Source

SQL12 lines
1CREATE FUNCTION dbo.QBM_FGIXOriginChanged_Effect(2  @XOriginOld int,3  @XOriginNew int,4  @XIsInEffectOld BIT,5  @XIsInEffectNew BIT6) RETURNS BIT7  WITH SCHEMABINDING8AS9BEGIN10  RETURN((sign(@XOriginOld) & sign(convert(int, @XIsInEffectOld))) ^(sign(@XOriginNew) & sign(convert(int,11  @XIsInEffectNew))))12END
Open raw exported source
SQL ยท Raw4 lines
1     create   function dbo.QBM_FGIXOriginChanged_Effect (@XOriginOld int , @XOriginNew int , @XIsInEffectOld bit , @XIsInEffectNew bit ) returns2 bit with SCHEMABINDING as begin return ( (sign(@XOriginOld) & sign(convert(int, @XIsInEffectOld))) ^ (sign(@XOriginNew) & sign(convert(int, @XIsInEffectNew3))) ) end 4