Question

题目级别：工程师【适中】

使用SQL语句建个存储过程proc_stu, 然后以student表中的学号Stu_ID为输入参数@s_no, 返回学生个人的指定信息。下面创建存储过程语句正确的是：( )

备选答案

create procedure [stu].[proc_student]
@s_no as int
as
begin
    select * from stu.student where stu_id=@s_no
end

create procedure [stu].[proc_student]
@s_no int
as
begin
    select * from stu.student where stu_id=@s_no
end

create procedure [stu].[proc_student]
@s_no int
as
begin
    select * from stu.student where s_no=@s_no
end

create procedure [stu].[proc_student]
@s_no as int
as
begin
    select * from stu.student where stu_id=@stu_id
end