
240 ◾ Cloud Database Development and Management
functions can be categorized into two types: inline function and multistatement function. For
an inline table function, the returned result set is generated by a single SELECT statement. In
a multistatement table function, a TABLE variable is used to store the rows returned from the
multiple SELECT statements.
To illustrate the use of inline table functions, let us consider a user-defined table function
that returns a result set that contains the information about a group of students who are enrolled
in the same class that teaches VB. e function and its application in a query are illustrated in ...