可以调用返回记录集并将这些值加载到变量中的sql存储过程吗?

请考虑以下SQL Server表和存储过程。

create table customers(cusnum int, cusname varchar(50))

insert into customers(cusnum, cusname) values(1, 'Ken')
insert into customers(cusnum, cusname) values (2, 'Violet') --The Wife

create procedure getcus 
  @cusnum int
as 
Begin
   select cusname
   from customers (nolock)
   where cusnum = @cusnum
End

您知道如何编写这样的t-sql代码:

declare @cusname varchar(50)

select @cusname = cusname
from customers 
where cusnum = 1

我能用我的存储过程做这个吗?

例如,代码如下所示:

declare @cusnum int
declare @cusname varchar(50)

set @cusnum = 1

exec @cusname = cusname pbogetcus @cusnum

提前谢谢。