sy6_4_1.sql

来自「关于SQL数据库的实验代码和程序及一些函数的应用」· SQL 代码 · 共 8 行

create proc pro_calage @code char(6),@age int output
as
   declare @birth varchar(4),@today varchar(4)
   select @birth=datename(year,birthday)
       from person
       where no=@code
   select @today=datename(year,getdate())
   select @age=convert(int,@today)-convert(int,@birth)