调用proc_stu存储过程，错误的是（）。CREATE PROCEDURE

7 查阅

调用proc_stu存储过程，错误的是（）。 CREATE PROCEDURE proc_stu @notpassSum int OUTPUT , @writtenPass int=60 , @labPass int=60 AS SELECT stuName,stuInfo,stuNo,writtenExam,labExam FROM stuInfoINNER JOIN stuMarks ON stuInfo.stuNo=stuMarks.stuNoWHERE writtenExam<@writtenPass OR labExam<@labPassSELECT @notpassSum=COUNT(stuNo) FROM stuMarks WHERE writtenExam<@writtenPass OR labExam<@labPass GO

EXEC proc_stu @sum OUTPUT , 604

EXEC proc_stu @sum OUTPUT , 64 , 78

EXEC proc_stu 604 , @sum OUTPUT

EXEC proc_stu @sum OUTPUT

参考答案:

SQL试