您所在位置：主题：关于存储过程的问题
bq852
[专家分：0] 发布于 2007-06-19 19:19:00
我在SQL中建立了一个存储过程，负责从三个表中检索数据，存储过程名为：pro_stu_info，大家帮我看看，
USE sc_information
IF EXISTS(Select name FROM sysobjects
where name="pro_stu_info" and type='p')
DROP PROCEDURE pro_stu_info
GO
CREATE PROCEDURE pro_stu_info
AS
select info_student.学号,姓名,课程号,课程名,成绩,平时表现
from info_student,info_class,stu_class
Where info_student.学号=stu_class.学号 AND stu_class.课程号=info_class.课程号
GO
总说错误207，列"pro_stu_info"不存在，
而且还说错误207,列"学号"不存在,列"课程号"不存在,是怎么回事,请大家帮我看看.
USE sc_information
IF EXISTS(Select name FROM sysobjects
where name="pro_stu_info" and type='p')
DROP PROCEDURE pro_stu_info
GO
CREATE PROCEDURE pro_stu_info
AS
select info_student.学号,姓名,课程号,课程名,成绩,平时表现
from info_student,info_class,stu_class
Where info_student.学号=stu_class.学号 AND stu_class.课程号=info_class.课程号
GO
总说错误207，列"pro_stu_info"不存在，
而且还说错误207,列"学号"不存在,列"课程号"不存在,是怎么回事,请大家帮我看看.
