Welcome Guest.

1Answers

Create a stored procedure whose function is to query the name of the student who did not take any courses and call this stored procedure.

Asked by: Douglas 316 views IT February 12, 2019

Create a stored procedure whose function is to query the name of the student who did not take any courses and call this stored procedure.

1 Answers

  1. +2Votes  

    statement, you see the match does not match Create proc proc1 @sname char (20), @cname char (20) AsSelect t1. student, t1. name, t2. course, t3. elective, t3. score From  Student t1, course t2, elective t3Where t1.student=t3.student and t2.course=t3. The course condition is to associate these three tables

    Sharon Moore- February 12, 2019 |