You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures. The
stored procedures will be named ABCSPA and ABCSPB. ABCSPA should be configured to return
a table and ABCSPB should be configured to return status code.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)
A.
You should consider configuring a Select statement option for ABCSPA.
B.
You should consider configuring a Select statement option for ABCSPB.
C.
You should consider configuring a return value option for ABCSPA.
D.
You should consider configuring a return value option for ABCSPB.
Explanation: