You are a database developer. You plan to design a database solution by using SQL Server
2008. Your company operates a fulfillment warehouse. The company has the following
business requirements: • The packing of items to fulfill orders is processed as quickly as
possible. • When the product picker indicates that a box is full, the exact items list of the
content and invoice are made available. You plan to design a Transact-SQL user-defined
function. The function must perform the following tasks: • Accept a list of value pairs named
ProductID and Quantity as input. • Retrieve the product price information from the
ProductPrice table. • Calculate the total price for each product. • Calculate the total price for
all products. • Return the detailed and aggregated totals. You need to design the function to
meet these requirements. You want to achieve this goal by using the minimum amount of
coding effort. What should you do?
A.
Create an inline table-valued function that accepts a table-valued parameter.
B.
Create a multistatement table-valued function that accepts an XML parameter.
C.
Create a multistatement table-valued function that accepts a table-valued parameter.
D.
Create an inline table-valued function that accepts an XML parameter.
Explanation: