Duration: 15:14 min
Summary: To continue our discussion of stored procedures we will create a simple database that contains one table names "Student". The table contains Id, FirstName, LastName, and Course. We will populate the table with some data, and start working on the stored procedures.
The first proc will return the students per class. So, we pass a parameter that represents the class, and the proc will return all students in the class. If the parameter is null, all students are listed. Then, we will see how we can call the proc.