Question: Create a stored procedure usp_StudentLogin that tests if a student exists. After the stored procedure name, you list all the parameters for the procedure. Parameters

Create a stored procedure usp_StudentLogin that tests if a student exists. After the stored procedure name, you list all the parameters for the procedure. Parameters are values the user must enter when they execute the procedure. In this case, you will just need the StudentKey. After the parameters, the 'AS' keyword signals the start of the content of the procedure, The first thing we are going to do is see if a record exists for the user in the student table. The BEGIN and END keywords mark the beginning and ending of the true block. If it does, it will return the student's last name. If it doesn't exist, we won't do anything. The application can test to see whether the name is returned
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
