Back to OIM Explorer

dbo.QBM_FGITimeZoneIdentifier

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 397 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

  • No direct source references extracted.

Complete Source

SQL20 lines
1CREATE FUNCTION dbo.QBM_FGITimeZoneIdentifier(2  @UID_DialogTimeZone varchar(38)3) RETURNS varchar(644)5AS6BEGIN7  RETURN(8  SELECT CASE9  WHEN z.UID_TimeZoneMS IS NULL THEN10  z.Ident_DialogTimeZone11  ELSE ms.Ident_DialogTimeZone12  END13  FROM dbo.DialogTimeZone z14  LEFT15  OUTER16  JOIN dbo.DialogTimeZone ms17    ON z.UID_TimeZoneMS = ms.UID_DialogTimeZone18  WHERE19    z.UID_DialogTimeZone = @UID_DialogTimeZone)20END
Open raw exported source
SQL ยท Raw4 lines
1    create   function dbo.QBM_FGITimeZoneIdentifier(@UID_DialogTimeZone varchar(38) ) returns varchar(64)   as begin return( select case when z.UID_TimeZoneMS2 is null then z.Ident_DialogTimeZone else ms.Ident_DialogTimeZone end from dbo.DialogTimeZone z left outer join dbo.DialogTimeZone ms on z.UID_TimeZoneMS3 = ms.UID_DialogTimeZone where z.UID_DialogTimeZone = @UID_DialogTimeZone ) end 4