UNIT 11 MOCK FLASHCARD

Front

_______________ are similar to those provided by SQL Server as standard. They are given a name and, optionally, a set of parameters. They are created for a database and can be used in scripts, stored procedures, triggers, and other user-defined functions within the database.

Back

User-defined functions

Front

_______________ return a single value and can optionally accept one or more parameters. The return value is a standard data type but cannot be a Text, NText, Image, or Timestamp.

Back

Scalar functions

Front

_______________ functions return a table variable and can accept arguments. They are often used as "parameterized views" as they can be included in place of tables in a query.

Back

Table-valued

Front

_______________ table-valued functions contain a single statement, which must be a SELECT. The results of the query become the return value of the function.

Back

Inline

Front

_______________ table-valued functions can include many statements similar to those in a stored procedure. The table structure to be returned is defined within the function.

Back

Multi-statement

Front

In SQL Server, the syntax for creating a function with no parameters includes the keywords _______________ and _______________ to define the function's body.

Back

BEGIN, END

Front

To call a scalar function in SQL Server, we use the _______________ schema prefix before the function name.

Back

dbo.

Front

The command _______________ is used to modify an existing function in SQL Server.

Back

ALTER FUNCTION

Front

_______________ table-valued functions do not include statements in a BEGIN/END block, instead, the body of the function is a SELECT statement.

Back

Inline

Front

The _______________ command is used in SQL Server to create a multi-statement table-valued function where a table variable is declared in the function header.

Back

RETURNS TABLE