How would you accomplish this?

You work as a SQL Server 2012 database developer at ABC.com. You are developing a database
driven Web application. The application executes a store procedure based on the location of the
web user.
The location of the Web user is determined by IP Geolocation. You want to develop a process that
will execute the correct stored procedure for every Web user based on the user’s location.
How would you accomplish this?

A.
You should make use of a foreach SQLCLR statement.

B.
You should make use of a scalar user-defined function.

C.
You should make use of an inline function.

D.
You should make use of a cursor.

Explanation: