WebSite Professional Server Self Test

DismissStudent Query

Robert B. Denny (18-Nov-95)
Database View
Used to dismiss a student from school, by name. This query contains a parameter [pName], the student's name. Referential integrity assures that all StudentsAndClasses records for this student will get deleted automatically.
PARAMETERS pName Text;
DELETE DISTINCTROW Students.*, Students.Name
FROM Students
WHERE ((Students.Name=[pName]));


WebSite Tech Support