The following question uses Microsoft SQL Server.

Create a simple stored procedure that does not expect any parameters and contains a single T-SQL statement.

Create the stored procedure as PurchaseOrderInfo

This stored Procedure should return a result set consisting of ProductName, PurchaseOrderID, PurchaseOrderDetailID, OrderDate, TotalDue and ReceivedQty.

Refer to the schema AdventureWorks2012.Production and AdventureWorks2012.Purchasing to access the necessary tables needed to generate the following output.

EXECUTE the stored procedure in 2 ways.

Using the simple EXECUTE keyword, and

Using EXECUTE command by adding a WITH RESULT SETS statement.

Show the CREATE PROC, both the EXECUTE statements and the two sets of result sets.

The result should yield 8845 records.

Question

The following question uses Microsoft SQL Server.

Create a simple stored procedure that does not expect any parameters and contains a single T-SQL statement.

Create the stored procedure as PurchaseOrderInfo
This stored Procedure should return a result set consisting of ProductName, PurchaseOrderID, PurchaseOrderDetailID, OrderDate, TotalDue and ReceivedQty.
Refer to the schema AdventureWorks2012.Production and AdventureWorks2012.Purchasing to access the necessary tables needed to generate the following output.
EXECUTE the stored procedure in 2 ways.
1. Using the simple EXECUTE keyword, and
2. Using EXECUTE command by adding a WITH RESULT SETS statement.
Show the CREATE PROC, both the EXECUTE statements and the two sets of result sets.
The result should yield 8845 records.

Accepted Answer

The Answer is in the image, click to view ...

Question