[1] Inline Functions

Question 1

In what major way do Inline Functions differ from Views?

Answer 1

An Inline Function can take parameters

Question 2

Write the Syntax used to create an Inline Function

Answer 2

CREATE FUNCTION schema.fn_functionname (@parameter int)
RETURN TABLE
AS
RETURN( SELECT…FROM)

Question 3

What is the purpose of the RETURN statement in an Inline Function?

Answer 3

the RETURN statement quite literally returns the embedded (in brackets) select statement.

Question 4

What is the purpose of the RETURN TABLE statement in the creation of an Inline Function?

Answer 4

This tells SQL that it is a table valued function as compared to a scalar valued function

Question 5

What are the two main types of Inline Functions?

Answer 5

Table-valued returns a table and Scalar-valued returns just one value.