存储过程返回值用关键字output

存储过程：

 

alter proc Bargain_messageContent
@userId int,@contents nvarchar(200) output
as
declare @guestName nvarchar(50), @sex nvarchar(2),@bargainName nvarchar(50)
declare @payMoney decimal(10,1),@privateSign nvarchar(50)
--declare @contents nvarchar(200)
set @contents=''
select @guestName=guestName, @sex=sex,@bargainName=bargainName,@payMoney=payMoney,@privateSign=privateSign
 from bargain ,Parameter
where bargain.id=2 and bargain.userId=parameter.userId
set @contents=@guestName
if (@sex='男')
set @contents=@contents+'先生'
else if(@sex='女')
set @contents= @contents+'女士'
set @contents=@contents+',您好!,合同”'+@bargainName+'“,定于*****,付款'+cast(@payMoney as nvarchar)+'元人民币'
set @contents=@contents+'请定时交付，以免带来不便.'+@privateSign
print @contents

运行：

declare @userId int,@contents nvarchar(200)
set @userId=2
exec Bargain_messageContent @userId,@contents output
print @contents

 

结果：

王政博,您好!,合同”测试合同2“,定于*****,付款0.0元人民币请定时交付，以免带来不便.王政博                                              
王政博,您好!,合同”测试合同2“,定于*****,付款0.0元人民币请定时交付，以免带来不便.王政博