filling ( more than one table ) in dataset using one stored proced

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all,

i would like to ask if it possible to fill one dataset using one stored
procedure.

for example:
if dataset has two tables: ( emp) and ( dept )

can i use the following stored procedure to fill them both:

< SQL CODE >

create procedure sp_get_emp_and_dept
AS
Begin

select * from emp

select * from dept

End
 
Back
Top