SQL语句取存储过程 return返回值

create proc test
as
return 1

declare @a char(1)
  exec  @a = test
print @a