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.)

Question

You develop a Microsoft SQL Server 2012 database. You need to create and call a stored procedure that meets the following requirements:

Which Transact-SQL statement or statements should you use? (Each correct answer presents part of the solution. Choose all that apply.)

Accepted Answer

C. Option C F. Option F

Answer

A. Option A

Answer

B. Option B

Answer

D. Option D

Answer

E. Option E

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…