You are updating a Virtual Earth 6.0 store locator. A database table named Stores contains the City and State fields. A Microsoft SQL Server 2005 function named CalculateDistance measures the distance between two points. The store locator contains a stored procedure named LookupStores that retrieves the names of stores located in a given city and state. The city and state are passed in as parameters to the stored procedure. You need to extend the store locator to support a proximity search within a given radius. Which two tasks should you perform? (Each correct answer presents part of the solution. Choose two.)
A.
Add a Radius field to the Stores table.
B.
Add a Distance field to the Stores table.
C.
Add Latitude and Longitude fields to the Stores table.
D.
Extend the LookupStores stored procedure to use CalculateDistance.
E.
Create a new stored procedure that uses CalculateDistance along with the result set from the LookupStores stored procedure.
F.
Create a new stored procedure that uses CalculateDistance along with the entire data set from the Stores table.