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
Explanation:
http://msdn.microsoft.com/en-us/library/ms186755.aspx
Functions cannot perform any of DDL {data definition language} which is for example table creation. Text says, that object should create table is it doesn’t exist so you can only use procedure.
‘d’ is the answer.
0
0