SqlServer 存储过程带输入和输出参数

从student表中选出ID为'00128'的学生的name

use university_database
go

create procedure Get_instructor_name2
@Set_ID varchar(10),
@Get_Name varchar(20) output
as
begin 
select @Get_Name=name
from student
where ID=@Set_ID;
end

declare @Get_Name varchar(20)
exec Get_instructor_name2  '00128',@Get_Name output
select @Get_Name as out_name