SQL Server: Stored Procedures

Description

A stored procedure is a named block of SQL code. Stored procedures can be reused and executed anytime.

In this lab, you will learn how to use Stored Procedures in SQL Server.

Based on this Customer and Supplier Schema, generate the solutions to the respective queries listed below:

1. Write a Stored Procedure that returns a list of customers who have ordered products from suppliers in their own country. This procedure should accept a Country argument.
2. Create a Procedure that lists all suppliers and their products.
3. Change the SupplierProducts Procedure to add a Country Column.
4. Rename the SupplierProducts stored procedure to ProductsBySupplier.

Lab Objective

Upon completion of this lab, you will be able to:

• Gain Hands-On Experience on SQL Server Stored Procedures.

Prerequisites

• You should have a conceptual understanding of Stored Procedures.
• You must have SQL Server Installed on your systems.