Back to OIM Explorer

dbo.QER_FGIOrderStateIsAssigned

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 282 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.QER_FGIOrderStateIsAssigned(2  @OrderState nvarchar(16)3) RETURNS int4  WITH SCHEMABINDING5AS6BEGIN7  DECLARE @erg int8  SELECT @erg = 09  IF @OrderState IN('Assigned',10  'OrderProlongate',11  'OrderUnsubscribe')12  BEGIN13    SELECT @erg = 114  END15  ende:16  RETURN(@erg)17END
Open raw exported source
SQL ยท Raw3 lines
1   create   function dbo.QER_FGIOrderStateIsAssigned(@OrderState nvarchar(16)) returns int with SCHEMABINDING as begin declare @erg int select @erg2 = 0       if @OrderState in ('Assigned', 'OrderProlongate', 'OrderUnsubscribe' ) begin select @erg = 1 end ende: return(@erg) end 3