You work as a Database Developer for Miracle Infocom. The company uses SQL server 2000 database to maintain data for the Human Resource department. You design a month salary sheet view, which joins several tables and calculates aggregate information. You want to provide a parameterized query to access the data contained in the salary sheet view. The output of this query will be used in other SELECT lists. What will you do?
A. Create an inline user-defined function that accepts the parameter as input.
B. B.Create a stored procedure that accepts the parameter as input and returns a rowset with the result set.
C. C.Create a scalar user-defined function that accepts the parameter as input.
D. D.Use an ALTER VIEW statement to add the parameter value to the view definition.
Answer:A
You work as a Database Developer for Miracle Infocom. The company uses SQL server 2000 database to maintain data for the Human Resource department. You design a month salary sheet view, which joins several tables and calculates aggregate information. You want to provide a parameterized query to access the data contained in the salary sheet view. The output of this query will be used in other SELECT lists. What will you do?
A. Create an inline user-defined function that accepts the parameter as input. B. B.Create a stored procedure that accepts the parameter as input and returns a rowset with the result set. C. C.Create a scalar user-defined function that accepts the parameter as input. D. D.Use an ALTER VIEW statement to add the parameter value to the view definition.