Getting Multiple Resultset using Single Stored Procedure
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