Back to OIM Explorer

dbo.QER_FTPersonFindByTSProp

Table FunctionSQL_TABLE_VALUED_FUNCTIONSandbox DB

Table Function.

Source: sandbox-db sys.sql_modules

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

SQL13 lines
1CREATE FUNCTION dbo.QER_FTPersonFindByTSProp(2  @CompareValue nvarchar(400)3) RETURNS @erg TABLE(UID_Person varchar(38)4)5AS6BEGIN7  INSERT INTO @erg(UID_Person)8  SELECT p.UID_Person9  FROM Person p10  WHERE11    p.CentralAccount = @CompareValue12  RETURN13END
Open raw exported source
SQL ยท Raw2 lines
1create   function dbo.QER_FTPersonFindByTSProp( @CompareValue nvarchar(400) ) returns @erg table (UID_Person varchar(38) ) as begin insert into 2@erg(UID_Person) select p.UID_Person from Person p where p.CentralAccount = @CompareValue return end