Back to OIM Explorer

dbo.QER_FGIMethodForPRNode

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 372 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_FTMethodForPRNode source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL14 lines
1CREATE FUNCTION dbo.QER_FGIMethodForPRNode(2  @UID_OrgPR varchar(38)3) RETURNS varchar(384)5AS6BEGIN7  DECLARE @UID_PWODecisionMethod varchar(38)8  DECLARE @PRs QBM_YSingleGUID9  INSERT INTO @PRs(UID_SingleGuid)10  SELECT @UID_OrgPR11  SELECT TOP 1 @UID_PWODecisionMethod = pr.UID_PWODecisionMethod12  FROM dbo.QER_FTMethodForPRNode(@PRs) pr13  RETURN(@UID_PWODecisionMethod)14END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QER_FGIMethodForPRNode (@UID_OrgPR varchar(38) ) returns varchar(38) as begin declare @UID_PWODecisionMethod varchar(382) declare @PRs QBM_YSingleGUID insert into @PRs(UID_SingleGuid) select @UID_OrgPR select top 1 @UID_PWODecisionMethod = pr.UID_PWODecisionMethod from dbo.QER_FTMethodForPRNode3 (@PRs ) pr return(@UID_PWODecisionMethod) end 4