sqlserver存储过程

create proc proempName
(
@id int output,--输入输出参数
@name varchar(20) out --输出参数
)
as
select @name=name from emp where id=@id


declare @pId int,
@pname varchar(200)
set @pId=1;
exec proempName @pId, @pname out
select @pname
print @pname