对于以下SQL语句建立的存储过程,调用时使用正确的调用方法为:() CREATE PROCEDURE proStudentBy
对于以下SQL语句建立的存储过程,调用时使用正确的调用方法为:() CREATE PROCEDURE proStudentByNo1(@sNo char(7)) AS SELECT a.studentNo, studentName, avg(score) FROM Student a, Score b WHERE a.studentNo=b.studentNo AND a.studentNo=@sNo GROUP BY a.studentNo, studentName
A、EXECUTE proStudentByNo1 ’1500001’
B、DECLARE @stuNO char(7) SET @stuNO=’1500003’ EXECUTE proStudentByNo1 @stuNO
C、EXECUTE PROCEDURE proStudentByNo1 ’1500001’
D、DECLARE @stuNO char(7) SET @stuNO=’1500003’ EXECUTE PROCEDURE proStudentByNo1 @stuNO