Back to OIM Explorer

dbo.QER_FTPersonHeadCirc_Person

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

Source size: 361 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_FTPersonHeadCirc_Person_i source text reference

References

Referenced By

Complete Source

SQL16 lines
1CREATE FUNCTION dbo.QER_FTPersonHeadCirc_Person(2  @UID_Person varchar(38),3  @UID_PersonHead varchar(38)4) RETURNS TABLE5AS6RETURN(7SELECT *8FROM dbo.QER_FTPersonHeadCirc_Person_i(@uid_person, @UID_PersonHead, CASE9WHEN @UID_Person > ' ' AND @UID_PersonHead > ' ' THEN10311WHEN @UID_Person > ' ' THEN12213WHEN @UID_PersonHead > ' ' THEN14115ELSE 016END))
Open raw exported source
SQL ยท Raw4 lines
1create function dbo.QER_FTPersonHeadCirc_Person( @UID_Person varchar(38)  , @UID_PersonHead varchar(38)   ) returns table as return ( select * from dbo.QER_FTPersonHeadCirc_Person_i2(@uid_person , @UID_PersonHead , case when @UID_Person > ' ' and @UID_PersonHead > ' ' then 3 when @UID_Person > ' ' then 2  when @UID_PersonHead > ' '3 then 1 else 0 end ) ) 4