Back to OIM Explorer

dbo.QER_FGIPWOSubmethodByMethodS

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 729 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_FGIPWOSubmethodByMethod source text reference

References

Referenced By

Complete Source

SQL28 lines
1CREATE FUNCTION dbo.QER_FGIPWOSubmethodByMethodS(2  @OrderState nvarchar(64),3  @UID_SubMethodOrderProduct varchar(38),4  @UID_SubMethodOrderUnsubscribe varchar(38),5  @UID_SubMethodOrderProlongate varchar(38)6) RETURNS varchar(387)8  WITH SCHEMABINDING9AS10BEGIN11  DECLARE @UID_PWODecisionSubMethod varchar(38)12  SELECT @UID_PWODecisionSubMethod = CASE @OrderState13  WHEN 'New' THEN14  @UID_SubMethodOrderProduct15  WHEN 'OrderProduct' THEN16  @UID_SubMethodOrderProduct17  WHEN 'OrderProlongate' THEN18  CASE19    WHEN @UID_SubMethodOrderProlongate > ' ' THEN20  @UID_SubMethodOrderProlongate21  ELSE @UID_SubMethodOrderProduct22  END23  WHEN 'OrderUnsubscribe' THEN24  @UID_SubMethodOrderUnsubscribe25  ELSE NULL26  END27  RETURN(@UID_PWODecisionSubMethod)28END
Open raw exported source
SQL ยท Raw6 lines
1     create   function dbo.QER_FGIPWOSubmethodByMethodS (@OrderState nvarchar(64)  , @UID_SubMethodOrderProduct varchar(38) , @UID_SubMethodOrderUnsubscribe2 varchar(38)  , @UID_SubMethodOrderProlongate varchar(38)  ) returns varchar(38) with SCHEMABINDING as begin declare @UID_PWODecisionSubMethod varchar(383) select @UID_PWODecisionSubMethod = case @OrderState  when 'New' then @UID_SubMethodOrderProduct when 'OrderProduct' then @UID_SubMethodOrderProduct when4 'OrderProlongate' then  case when @UID_SubMethodOrderProlongate > ' ' then @UID_SubMethodOrderProlongate else @UID_SubMethodOrderProduct end  when 'OrderUnsubscribe'5 then @UID_SubMethodOrderUnsubscribe else null end return (@UID_PWODecisionSubMethod) end 6