Thanks ck9663 ,
I check with microsoft as well they says-
"In sort, there's no way to actually "name" your result sets. You're stuck using the 0-based result set ordinal in your client code.
Sorry!
Aaron Alton | [COLOR=#0072bc]thehobt.blogspo t.com[/COLOR]"
dewraj
Last Activity: Aug 13 '09, 12:41 PM
Joined: Dec 8 '08
Location:
-
ok,thanks,I will do.
however is it possible to name mutiple record set in store procedure ?
something like -
create proc mutiDataSet
As
Begin
(select * from temp1) as EmpData
(select * from temp2) as DeptData
End
thanksLeave a comment:
-
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...Leave a comment:
-
Mutiple Table from Stored procedure
Hi
I am using windows applicaiton(.ne t) as front end,
and I want to get mutiple tables in Dataset by executing a single stored procedure i.e.
SP would return mutiple tables (record sets) with the user specified name.
can anybody guide me no this?
thanks.
No activity results to display
Leave a comment: