Question

数据库存储过程能返回多个结果集吗？

如题

Answer 1

存储过程没有返回值，函数才有返回值，也可以返回一个表的数据，，不知道你所说的结果集是不是表的意思.

Answer 2

create table test
(
id int identity primary key,
name varchar(50)
)
go
insert into test
select 'aaa' union
select 'bbb' union
select 'ccc'
go
select * from test
go
--创建存储过程
if exists(select * from sysobjects where name='proc_test1')
drop procedure proc_test1
go
create procedure proc_test1
as
begin
declare @table table(id int,name varchar(50))
declare @table1 table(id int,name varchar(50))
insert into @table select * from test
insert into @table1 select * from test
select * from @table
select * from @table1
end
--返回表
exec proc_test1