You work as a database developer at ABC.com. ABC.com has a SQL Server 2012 database
infrastructure with a very large database named SalesDB. You create a new table named
SalesHistory that will hold historical data from the SalesDB database.
You need to perform a batch update from the SalesDB database to the SalesHistory table. You
want the status information from the batch process to be logged to a SQL Server table that must
be created by the batch process.
How would you accomplish this task?
A.
You should make use of the FORMAT function.
B.
You should make use of the CONVERT function.
C.
You should make use of a scalar user-defined function.
D.
You should make use of an inline function.
E.
You should make use of a table-valued function.
F.
You should make use of a stored procedure.
Explanation: