Question

创建一个带有参数的存储过程Stu_Age,该存储过程根据传入的学生编号,在T_STUDENT中计算此学生的年龄,并根据

Answer 1

PROCEDURE STU_AGE (@STU_ID varchar(30),@AGE INT OUT)
BEGIN
SET NOCOUNT ON;
SELECT @AGE = YEAR(GETDATE()) - CAST(SUBSTRING(SFZHM,7,4) AS INT) FROM T_STUDENT WHERE STU_ID = @STU_ID;
END

--SFZHM,身份证号码。
--如果你有别的能算年纪的，你说出来我在帮你改写。

Answer 2

procedure stu_age (stu_id_in varchar2(30) in, stu_age_out int out )
begin
select stu_age into stu_age_out from t_student where stu_id = stu_id_in;
end;