vasanth krishna

vasanth krishna

  • NA
  • 44
  • 54.8k

Getting Multiple Resultset using Single Stored Procedure

Sep 11 2013 2:05 PM
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)