Knowledge check

What is the most straightforward way to pass values to a stored procedure?

Store the value in a temporary table

Use an output parameter

Use an input parameter

How do you access an output parameter from a stored procedure?

Execute the stored procedure and view the recordset returned

Declare a variable and pass it as an output parameter when you execute the stored procedure

Declare a variable inside the stored procedure and then view it after you run the stored procedure

Where can you use a table-valued function?

Only inside stored procedures

Anywhere in SQL that you can use a table

When you need to update rows

You must answer all questions before checking your work.

Feedback