Duration: 21:16 min
Summary: Now, we will create two more stored procedures that insert a new record into the student table and update an existing record. For the insert, we have three parameters passed in (the Id is already an identity). After we are done creating the procedure, we will call it with some variables. The update proc will update the old course to a new course. Both courses are passed as parameters.
There is an additional parameter to the proc that is an output parameter. This parameter will return the number of records affected (in other words, how many courses were affected by the change). Finally, we will call the proc and see how to get the value from the output parameter.