Back to OIM Explorer

dbo.QER_FGIPWOSubmethodByMethod

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 502 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QER_FGIPWOSubmethodByMethodS source text reference

References

Referenced By

Complete Source

SQL18 lines
1CREATE FUNCTION dbo.QER_FGIPWOSubmethodByMethod(2  @OrderState nvarchar(64),3  @uid_PWODecisionMethod varchar(38)4) RETURNS varchar(385)6AS7BEGIN8  DECLARE @UID_PWODecisionSubMethod varchar(38)9  SELECT10    @UID_PWODecisionSubMethod = dbo.QER_FGIPWOSubmethodByMethodS(@OrderState,11    dm.UID_SubMethodOrderProduct,12    dm.UID_SubMethodOrderUnsubscribe,13    dm.UID_SubMethodOrderProlongate)14  FROM pwodecisionmethod dm15  WHERE16    dm.uid_PWODecisionMethod = @uid_PWODecisionMethod17  RETURN(@UID_PWODecisionSubMethod)18END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QER_FGIPWOSubmethodByMethod (@OrderState nvarchar(64)  , @uid_PWODecisionMethod varchar(38) ) returns varchar(38)  as begin2 declare @UID_PWODecisionSubMethod varchar(38) select @UID_PWODecisionSubMethod = dbo.QER_FGIPWOSubmethodByMethodS( @OrderState, dm.UID_SubMethodOrderProduct3, dm.UID_SubMethodOrderUnsubscribe, dm.UID_SubMethodOrderProlongate) from pwodecisionmethod dm where dm.uid_PWODecisionMethod = @uid_PWODecisionMethod 4return (@UID_PWODecisionSubMethod) end 5