Create a SQL stored procedure called SignUpForShift, which takes a VolunteerPersonID, Date, DepartmentID, and JobID as input
Fantastic news! We've Found the answer you've been seeking!
Question:
Create a SQL stored procedure called SignUpForShift, which takes a VolunteerPersonID, Date, DepartmentID, and JobID as input and adds a new entry to the Volunteer,Schedule tables for that volunteer on that date. This stored procedure can be used by volunteers to sign up for available shifts.
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date: