thanks ck9663,
Please have look,
create proc mutiDataSet
As
Begin
select * from temp1
select * from temp2
End
I need to create one procedure in above way but when it execute it returns mutiple record set to front end application e.g. .net dataset
those tables can be accessed in following way.
ds.table[0].
ds.table[1].
but inspite of putting 0,1.... I want get some table name form SP
somthing like -
create proc mutiDataSet
As
Begin
(select * from temp1) as EmpData
(select * from temp2) as DeptData
End
so that I can access in below way
ds.table[EmpData].
ds.table[DeptData].
how it can be possible?
|