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
接收三个返回参数 考虑把三个串用逗号隔开,然后做为一个变量传出去.
最新推荐文章于 2021-04-14 14:51:05 发布