1. TARGIT Community
  2. Documentation
  3. Data Warehouse: TARGIT InMemory
  4. Functions and Stored Procedures

INLINE TABLE VALUE FUNCTIONS

Avatar
Ole Dyring

A simplified version of a table value function with one SQL statement. It is not necessary to declare the
output table format. The following example shows how to declare an inline table value function with one
parameter, and how to call it from a SELECT statement.

Example:

CREATE FUNCTION getOrder ( @orderid int ) 
RETURNS TABLE 
as RETURN ( select * from orders where orderid in (@orderid ) ) 
select * from getOrder(10248) as OrderInfo
Was this article helpful?
0 out of 0 found this helpful

Comments

1 comment
Date Votes
  • Avatar
    Kristoffer Refslund

    Er dette eksempel også gældende for 2022 Winter update 2?

    0

Please sign in to leave a comment.

Articles in this section