kamal6666 بتاريخ: 14 مايو 2009 تقديم بلاغ مشاركة بتاريخ: 14 مايو 2009 create two tablesexam ( ex_id, ex_subject,ex_date,ex_limit) andstudent_exam(examid,student_id).insert the following row into the exam table:1, 'database design', '06/06/2003', 3insert into the student_exam table the following two records:1, 1112, 2221. create a stored procedure for registering student for an exam.the stored procedure has to guarantee that more students cannot register for a certain exam than given limit in the exam table . the input parameters of the stored procedure are the exam id and the student id.2. open tow windows . and try to execute the stored procedure with two different input parameters : try to register both the student with id 333 and with 444 for the exam 1.what is happening ? why?3. insert a new condition into the stored procedure it's not allowed to register for an exam after the beginning of the exam? اقتباس رابط هذا التعليق شارك المزيد من خيارات المشاركة
Recommended Posts
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.