·¢²¼Ê±¼ä : ÐÇÆÚËÄ ÎÄÕÂÊý¾Ý¿âʵÑ鱨¸æ(7¸öʵÑéÍêÕû¸½½Øͼ)¸üÐÂÍê±Ï¿ªÊ¼ÔĶÁ
µ÷ÓÃCALL COMPA0('2012001','2012002',@BJ);ºó²éѯÍêµÄ½á¹û²»ÕýÈ·£¬ ½«Ìõ¼þ IF Sno1>Sno2 THEN ¸ÄΪ IF SR1>SR2 THEN ºó²éѯÐÅÏ¢ÕýÈ·¡£
3
Ìáʾ³öÏÖÓï·¨´íÎó£¬Ó¦ÔÚ¡°DROP TRIGGER teacher_Income ON teacher¡±ÖÐ µÄ¡°ON teacher¡± ɾ³ý£¬È»ºóÔÙÔËÐУº
Áù¡¢ÊµÑé½á¹û ʵÑéÇ°£º Student:
Student1:
Teacher:
SC:
Course:
ʵÑé½Øͼ 1¡¢´æ´¢¹ý³Ì£º
2¡¢´¥·¢Æ÷£º£º £¨1£© student±í£º
£¨2£© student±í£º
Student1񡜧
£¨3£©
Æß¡¢×ܽá
ͨ¹ýÕâ´ÎʵÑ飬ÕÆÎÕÁË´æ´¢¹ý³ÌµÄ´´½¨ºÍµ÷Ó÷½·¨ÒÔ¼°´¥·¢Æ÷µÄ´´½¨¡¢É¾³ý ²Ù×÷£»Á˽âÁË´¥·¢Æ÷ÔÚÊý¾Ý¿âÖÐËùÆðµ½µÄ×÷Óã¬ËüÊÇÊý¾Ý¿âÍêÕûÐÔµÄÒ»¸öÖØÒª·½ ·¨£»¹®¹ÌÁË´æ´¢¹ý³ÌºÍ´¥·¢Æ÷µÄ»ù±¾¸ÅÄî¡£