You develop a Microsoft SQL Server 2012 database. You need to create and call a stored
procedure that meets the following requirements:
– Accepts a single input parameter for CustomerID.
– Returns a single integer to the calling application.
Which Transact-SQL statement or statements should you use? (Each correct answer presents part
of the solution. Choose all that apply.)

A.
Option A

B.
Option B

C.
Option C

D.
Option D

E.
Option E

F.
Option F