haramisra
asked on
but how do you get multiple resultsets if the stored procedure returns more than one?
but how do you get multiple resultsets if the stored procedure returns more than one?
In VB, we must use rs.NextRecordset to advance to the following recordset.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Another newbie!
Welcome to EE vk_naga .
I see nothing in your comment that refers to multiple resultsets!
The etiquette suggest that you never post ANSWERS. Only COMMENTS. Take some time to read http://206.169.61.185/Databases/Microsoft_SQL_Server/cmtyQuestAnswer.jsp
Welcome to EE vk_naga .
I see nothing in your comment that refers to multiple resultsets!
The etiquette suggest that you never post ANSWERS. Only COMMENTS. Take some time to read http://206.169.61.185/Databases/Microsoft_SQL_Server/cmtyQuestAnswer.jsp
ASKER
I want to retrieve 2 different kind of result sets returned from a Stored procedure , inside a calling stored procedure .
Lets say i execute sp_spaceused with no parameter .It returns2 rows , how to handle that when i execute inside a stored procedure ?
/* Sample code */
create procedure p_test
as
begin
-- insert into #t1
exec sp_spaceUsed
end
Lets say i execute sp_spaceused with no parameter .It returns2 rows , how to handle that when i execute inside a stored procedure ?
/* Sample code */
create procedure p_test
as
begin
-- insert into #t1
exec sp_spaceUsed
end