网站 › 『 Sybase Other 』 › 求助一触发器问题啊

knightda 发表于 2007-11-22 15:42:48

求助一触发器问题啊

<p><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"></span></p><p><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">用查询分析器创建一触发器</span><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-fareast-font-family: 宋体;"><span style="mso-tab-count: 1;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>trigger_1</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">，实现当删除课程表中某门课程的记录时，对应学生成绩表中所有有关此课程的选课记录均删除其中<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;">课程表<span lang="EN-US" style="COLOR: blue;">KC （课程号，课程名，教师，开课学期，学时，学分）课程号为主键</span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;"><span lang="EN-US" style="COLOR: blue;"><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><font color="#000000">成绩表</font><span lang="EN-US" style="COLOR: blue;">XS_KC（学号，课程号，成绩） 学号为主键</span></span></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;"><span lang="EN-US" style="COLOR: blue;"><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span lang="EN-US" style="COLOR: blue;"></span></span></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;"><span lang="EN-US" style="COLOR: blue;"><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span lang="EN-US" style="COLOR: blue;">希望高手帮忙啊</span></span></span></span></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;">课程表<span lang="EN-US" style="COLOR: blue;">KC （课程号，课程名，教师，开课学期，学时，学分）课程号为主键</span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;"><span lang="EN-US" style="COLOR: blue;"><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><font color="#000000">成绩表</font><span lang="EN-US" style="COLOR: blue;">XS_KC（学号，课程号，成绩） 学号为主键</span></span></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;"><span lang="EN-US" style="COLOR: blue;"><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span lang="EN-US" style="COLOR: blue;"></span></span></span></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 26.25pt; mso-char-indent-count: 2.5;"><span style="FONT-FAMILY: 宋体; mso-bidi-font-size: 10.5pt;"><span lang="EN-US" style="COLOR: blue;"><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-family: &quot;Times New Roman&quot;; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span lang="EN-US" style="COLOR: blue;">希望高手帮忙啊</span></span></span></span></p>

lovelyni 发表于 2007-12-19 22:06:58

顶一下

查看完整版本: 求助一触发器问题啊