SQL Server Stored Procedures

Home/Development, SQL Server/SQL Server Stored Procedures

SQL Server Stored Procedures

$15.00 $4.00

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

Categories: ,

Description

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

Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.