subject_64806.htm

vc

<p>
序号：64806 发表者：黄本 发表日期：2003-12-12 22:56:57
<br>主题：存储过程相关问题！
<br>内容：我建了2表<BR>STU_GRADE 放学生成绩<BR>STU_DOCUEM 放学生档案！<BR>2表PRIMARY KEY 都为STU_NUM<BR><BR>写了如下几句话！<BR><BR>use pubs<BR><BR>declare @all_gra float,@avg_gra float<BR>go<BR>create procedure search_1<BR>@ch_name<BR>as/*notice don't neglect!!!!!*/<BR><BR>select s_d.stu_name as 'Student_name',<BR>s_d.stu_num as 'Student_num',<BR>@all_gra=(S_g.chn+S_g.maths+S_g.eng+S_g.phc+S_g.chm) as 'All_grades',<BR>@avg_gra=(@all_gra/4) as 'Average_grade'<BR>from stu_grade as s_g,stu_docum as S_d<BR>where s_d.stu_num=S_g.stu.num and @ch_name=s_d.stu_name<BR><BR>--------------------------------------------<BR>查询 学生成绩！<BR>可COMPLIE 时 说<BR>服务器: 消息 156，级别 15，状态 1，过程 search_1，行 5<BR>在关键字 'select' 附近有语法错误。<BR>服务器: 消息 156，级别 15，状态 1，过程 search_1，行 7<BR>在关键字 'as' 附近有语法错误。<BR><BR><BR>到底错哪里了！<BR>2003-12-13 12:41:05