3
Answers

Getting Multiple Resultset using Single Stored Procedure

Ask a question
i have two table like

emp_detail
emp_contact

m using stored procedure to get the output

create procedure pro
as
begin
select * from emp_detail
select * from emp_contact
end

is this correct or any other way in sql server

Answers (3)