接收三个返回参数 考虑把三个串用逗号隔开,然后做为一个变量传出去.

本文介绍了一个使用SQL存储过程的示例,该过程从三个不同的表中获取计数,并将这些计数组合成一个字符串输出。此外,还展示了如何解析这个字符串以分别获取每个表的记录数。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

create procedure my_proc @str varchar(20) OUTPUT
as
begin
 
declare @i1 as int
 
declare @i2 as int
 
declare @i3 as int
 
select @i1 = count(1) from authors
 
select @i2 = count(1) from discounts
 
select @i3 = count(1) from employee
 
set @str = ltrim(@i1) + '.' + ltrim(@i2) + '.' + ltrim(@i3)
end
go

declare @str as varchar(20)
exec my_proc @str OUTPUT

select @str

/*
                    
--------------------
23.3.43

(所影响的行数为 1 行)
*/

select parsename(@str,3) authors,
      
parsename(@str,2) discounts,
      
parsename(@str,1) employee
/*
authors                                                                                                                          discounts                                                                                                                        employee                                                                                                                        
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------
23                                                                                                                               3                                                                                                                                43

(所影响的行数为 1 行)

*/

drop proc my_proc

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值