Here is another popular lab from Hands-On-Lab library: SQL Server Stored Procedures.
A Stored Procedure is a group of one or more T-SQL statements into a logical unit. Stored Procedure accepts three types of parameters input parameters, output parameters and table-valued input parameters.
1. Input parameters pass data into a stored procedure and it can be defined by using IN keyword.
2. Output parameters returns the data back to the user and it can be defined by using OUT keyword.
3. Table-Valued parameters pass multiple rows of data into a stored procedure and it can be defined by using user-defined table types.
This lab is divided into seven exercises explaining how to create the stored procedures with input, output and table valued parameters and modifying data using stored procedure.
Exercise 1: CREATE a PROCEDURE without parameters
Exercise 2: CREATE a PROCEDURE using Input Parameters
Exercise 3: CREATE a PROCEDURE using Output Parameters
Exercise 4: CREATE a PROCEDURE using Table-Valued Parameters
Exercise 5: Modifying data using a Stored Procedure
Exercise 6: Self-Assessment
Exercise 7: T-SQL Challenge
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.