Back to OIM Explorer

dbo.QER_FTCentralAccount

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 669 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.QER_FTMailAddressSource source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL26 lines
1CREATE FUNCTION dbo.QER_FTCentralAccount(2  @AccountName nvarchar(256)3) RETURNS TABLE4AS5RETURN(6SELECT7  convert(varchar(30), a.TableName) AS TableName,8  convert(varchar(30), a.columnname) AS ColumnName,9  convert(nvarchar(256), a.accountName) AS AccountName,10  a.XObjectKey AS XObjectKey,11  p.XObjectKey AS ObjectKeyPerson12FROM QERCentralAccount a13LEFT14OUTER15JOIN person p16  ON a.UID_Person = p.UID_Person17WHERE18  a.AccountName > ' ' AND a.AccountName LIKE @AccountName19UNION all20SELECT21  f.TableName,22  f.columnname,23  substring(f.smtp, 1, charindex(N '@', f.smtp) -1),24  f.XObjectKey,25  f.ObjectkeyPerson26FROM dbo.QER_FTMailAddressSource(@AccountName + N '@%') AS f)
Open raw exported source
SQL ยท Raw6 lines
1create function dbo.QER_FTCentralAccount (@AccountName nvarchar(256) ) returns table       as return (  select convert(varchar(30), a.TableName ) as TableName2 , convert(varchar(30),a.columnname) as ColumnName , convert(nvarchar(256) , a.accountName) as AccountName , a.XObjectKey as XObjectKey , p.XObjectKey 3as ObjectKeyPerson from QERCentralAccount a left outer join person p on a.UID_Person = p.UID_Person where a.AccountName > ' ' and a.AccountName like @AccountName4 union all  select f.TableName, f.columnname, substring(f.smtp, 1, charindex(N'@',f.smtp )-1), f.XObjectKey, f.ObjectkeyPerson from dbo.QER_FTMailAddressSource5(@AccountName + N'@%') as f ) 6