SQL Server: Stored Procedures

Level : Beginner
Mentor: Shailendra Chauhan
Type : GuidedLab
Points : 10
Duration : 00:25:00

Lab Details

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.


Self-paced Membership
  • 24+ Video Courses
  • 825+ Hands-On Labs
  • 400+ Quick Notes
  • 125+ Skill Tests
  • 10+ Interview Q&A Courses
  • 10+ Real-world Projects
  • Career Coaching Sessions
  • Email Support
Upto 60% OFF
Know More
Still have some questions? Let's discuss.
CONTACT US
Accept cookies & close this