You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5.
You evaluate the design of a Microsoft SQL Server 2005 database that stores data for the application.
Several queries share a common SELECT statement.
The only difference between the SELECT statement in each query is a parameter that is used in the WHERE clause.
The SELECT statement is used in joins and subqueries.
You need to ensure that the database queries can be easily maintained.
What should you do?
A.
Use a view.
B.
Use a trigger.
C.
Use a stored procedure.
D.
Use a table-valued function.