What are two possible ways to achieve this goal?

Your company has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

Your company has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

A.
Create a function that returns a list of values that represent the login times for the given user.

B.
Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.

C.
Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.

D.
Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.



Leave a Reply 0

Your email address will not be published. Required fields are marked *