It is possible to retrieve multiple datasets by specifying
more than 1 select statement within a SQL stored procedure.
Is is also possible to pass more than one select statement
as a command.Text? If I remember correctly, it was
possible to do so with recordsets using ADO by separating
select statements with a semicolon (select * from table A;
select * from table B).
Thanks in advance,
Max.
--
HTH,
Manoj G
"Max" <deve...@woolworths.com.au> wrote in message
news:1a5101c2ee79$5a393fb0$a301...@phx.gbl...
> Hi,
>
> It is possible to retrieve multiple datasets by specifying
> more than 1 select statement within a SQL stored procedure.
[Manoj] No, I suppose you will have multiple DataTable objects within the
same DataSet instead.
>
> Is is also possible to pass more than one select statement
> as a command.Text? If I remember correctly, it was
> possible to do so with recordsets using ADO by separating
> select statements with a semicolon (select * from table A;
> select * from table B).
[Manoj] Yes , very much possible.
>
> Thanks in advance,
>
> Max.