Case Study:
Leafield Solutions
The performance of the SPUpdate2 stored procedure needs to be improved. Your solution must meet the
design requirements. What should your solution include?

A.
A common table expression.

B.
A derived table.

C.
A Cursor.

D.
A table variable.