Back to OIM Explorer

dbo.QBM_FCVGuidToReplace38

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 398 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL21 lines
1CREATE FUNCTION dbo.QBM_FCVGuidToReplace38(2  @Value varchar(38),3  @UID_Database varchar(38)4) RETURNS varchar(385)6AS7BEGIN8  DECLARE @Erg varchar(38)9  DECLARE @Work varchar(38) = NULL10  SELECT @Erg = @value11  SELECT TOP 1 @Work = r.GuidNew12  FROM dbo.QBMGuidReplace r13  WHERE14    r.GuidOld = @Value AND UID_Database = @UID_Database15  IF @Work > ' '16  BEGIN17    SELECT @Erg = @Work18  END19  endLabel:20  RETURN(@erg)21END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FCVGuidToReplace38(@Value varchar(38) ,@UID_Database varchar(38) ) returns varchar(38)   as begin declare @Erg varchar2(38) declare @Work varchar(38) = null select @Erg = @value select top 1 @Work = r.GuidNew from dbo.QBMGuidReplace r where r.GuidOld = @Value and UID_Database3 = @UID_Database if @Work > ' ' begin select @Erg = @Work end endLabel: return(@erg) end 4