3
Answers

Getting Multiple Resultset using Single Stored Procedure

vasanth krishna

vasanth krishna

11y
1.3k
1
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)