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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling a dataset using one stored procedure 2
Call stored procedure with paremeter output in c# 7
How can an output parameter update a DataTable in a DataSet 0
Store XML/XSD in SQL Server 2008 3
basic dataset/table question 1
Filling a muti-table typed dataset using a stored procedure 5
Fill typed dataset with one stored procedure call 3
problem with dataset constraints 2

Top