Back to OIM Explorer

dbo.QBM_FCVGuidToNoTransfer

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 513 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.QBM_FGIGuidIsValid source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL15 lines
1CREATE FUNCTION dbo.QBM_FCVGuidToNoTransfer(2  @GuidTransferable varchar(38),3  @ModuleName varchar(3)4) RETURNS varchar(385)6AS7BEGIN8  RETURN(CASE9  WHEN dbo.QBM_FGIGuidIsValid(@GuidTransferable) & 4 > 0 AND10  LEFT(@GuidTransferable, 3) = @ModuleName THEN11  CONCAT(substring(@GuidTransferable, 5, 8), '-', substring(@GuidTransferable, 13, 4), '-', substring(@GuidTransferable,12  17, 4), '-', substring(@GuidTransferable, 21, 4), '-', substring(@GuidTransferable, 25, 12))13  ELSE @GuidTransferable14  END)15END
Open raw exported source
SQL ยท Raw5 lines
1    create   function dbo.QBM_FCVGuidToNoTransfer( @GuidTransferable varchar(38) , @ModuleName varchar(3) ) returns varchar(38) as begin return 2( case when     dbo.QBM_FGIGuidIsValid(@GuidTransferable) & 4 > 0 and LEFT(@GuidTransferable, 3) = @ModuleName  then concat(substring(@GuidTransferable3,5,8) , '-' , substring(@GuidTransferable,13,4) , '-' , substring(@GuidTransferable,17,4) , '-' , substring(@GuidTransferable,21,4) , '-' , substring(@GuidTransferable4,25,12) ) else @GuidTransferable end ) end 5