Back to OIM Explorer

dbo.QBM_FCVGUIDToModuleOwner

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 296 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_FGIModuleExists source text reference

Complete Source

SQL17 lines
1CREATE FUNCTION dbo.QBM_FCVGUIDToModuleOwner(2  @GUID varchar(38)3) RETURNS varchar(34)5AS6BEGIN7  RETURN(CASE8  WHEN ISNULL(@GUID, '') = '' THEN9  ''10  WHEN @GUID NOT LIKE '[a-z][0-z][0-z]-%' THEN11  'CCC'12  WHEN dbo.QBM_FGIModuleExists(13  LEFT(@GUID, 3)) = 1 THEN14  LEFT(@GUID, 3)15  ELSE 'ZZZ'16  END)17END
Open raw exported source
SQL ยท Raw3 lines
1      create   function dbo.QBM_FCVGUIDToModuleOwner(@GUID varchar(38)) returns varchar(3)  as begin return ( case when ISNULL(@GUID, '') = '' then2 '' when @GUID not like '[a-z][0-z][0-z]-%' then 'CCC' when dbo.QBM_FGIModuleExists(left(@GUID, 3)) = 1 then left(@GUID, 3) else 'ZZZ' end ) end 3