Back to OIM Explorer

dbo.QER_FTMailAddressSource

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

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

SQL25 lines
1CREATE FUNCTION dbo.QER_FTMailAddressSource(2  @EMail nvarchar(256)3) RETURNS TABLE4  WITH schemabinding5AS6RETURN(7SELECT8  t.TableName AS TableName,9  c.Columnname AS columnname,10  a.SplittedElement AS smtp,11  a.ObjectKeyOwner AS XObjectKey,12  p.XObjectKey AS ObjectkeyPerson13FROM dbo.QBMSplittedLookup a14JOIN dbo.DialogColumn c15  WITH(readpast)16  ON c.UID_DialogColumn = a.UID_DialogColumn17JOIN dbo.DialogTable t18  WITH(readpast)19  ON c.UID_DialogTable = t.UID_DialogTable20LEFT21OUTER22JOIN dbo.Person p23  ON a.uid_person = p.UID_Person24WHERE25  a.SplittedElementType = 'EMail' AND a.SplittedElement LIKE @EMail)
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.QER_FTMailAddressSource (@EMail nvarchar(256) )  returns table with schemabinding as return(  select t.TableName as TableName , c.Columnname2 as columnname , a.SplittedElement as smtp , a.ObjectKeyOwner as XObjectKey , p.XObjectKey as ObjectkeyPerson from dbo.QBMSplittedLookup a join dbo.DialogColumn3 c with (readpast) on c.UID_DialogColumn = a.UID_DialogColumn join dbo.DialogTable t with (readpast) on c.UID_DialogTable = t.UID_DialogTable left outer4 join dbo.Person p on a.uid_person = p.UID_Person where a.SplittedElementType = 'EMail' and a.SplittedElement like @EMail ) 5