Back to OIM Explorer

dbo.QBM_FGIUID_DialogColumn

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 467 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_FCVStringToGUID source text reference
  • references source dbo.QBM_FGIDBOwner source text reference

References

Referenced By

Complete Source

SQL20 lines
1CREATE FUNCTION dbo.QBM_FGIUID_DialogColumn(2  @TableName varchar(30),3  @ColumnName varchar(30),4  @dbOwner varchar(3) = NULL5) RETURNS varchar(386)7AS8BEGIN9  DECLARE @erg varchar(38)10  DECLARE @dbowner_intern varchar(3) = @dbOwner11  IF isnull(@dbowner_intern,12  '') = ''13  BEGIN14    SELECT @dbowner_intern = dbo.QBM_FGIDBOwner()15  END16  SELECT17    @erg = dbo.QBM_FCVStringToGUID(@dbowner_intern,18    CONCAT(@ColumnName, @TableName, @dbowner_intern)) endLabel:19  RETURN(@erg)20END
Open raw exported source
SQL ยท Raw5 lines
1    create   function dbo.QBM_FGIUID_DialogColumn( @TableName varchar(30) , @ColumnName varchar(30) , @dbOwner varchar(3) = null  ) returns varchar2(38) as begin declare @erg varchar(38) declare @dbowner_intern varchar(3) = @dbOwner if isnull(@dbowner_intern, '') = '' begin select @dbowner_intern =3 dbo.QBM_FGIDBOwner() end select @erg = dbo.QBM_FCVStringToGUID(@dbowner_intern , concat(@ColumnName , @TableName, @dbowner_intern) ) endLabel: return(@erg4) end 5