Batch Process in TSQL using Scalar user defined functions
I have received the following question which I have been told that the
answer is A-
You develop a Microsoft SQL Server 2012 database. You need to create a
batch process that meets the following requirements: • Status information
must be logged to a status table. • If the status table does not exist at
the beginning of the batch, it must be created. Which object should you
use?
A. Scalar user-defined function B. Inline user-defined function C.
Table-valued user-defined function D. Stored procedure
Answer is A
I have searched around and I still have problems understanding this
question. Why is the Answer supposedly A? What is special about batch
processing in this conext
No comments:
Post a Comment