Hi,
Consider one postmaster that manages multiple databases (logical names)
Is it possible (and how) to access a stored procedure or view/Table which
resides in DB aaa if your DB-connection has currently the context on DB bbb?
So: I login on db bbb as a user who has rights on both DBs (aaa,bbb).
am 04.02.2005, um 12:00:17 +0100 mailte KÖPFERL Robert folgendes:
> Hi,
>
> Consider one postmaster that manages multiple databases (logical names)
>
> Is it possible (and how) to access a stored procedure or view/Table which
> resides in DB aaa if your DB-connection has currently the context on
I don't work with M$ DBs, but saw that "autonumber" is an M$ concept.
Purely for my own edification, how do you get the most resent value of an
autonumber in M$? I was helping someone out who was using M$ stuff and was
amazed that there was no currval function.
Thanks,
Rick
> I don't work with M$ DBs, but saw that "autonumber" is an M$ concept.
> Purely for my own edification, how do you get the most resent
> value of an autonumber in M$? I was helping someone out who
> was using M$ stuff and was amazed that there was no currval function.
I beleive they call it ID
Michael,
That's an excellent solution, but on my table, the explain plan sucks
and the query time is over 3 minutes when implemented. Is there a
simple way to get a row_num without using a temporary sequence?
Thanks for your help.
-Don
On Fri, 4 Feb 2005 14:02:20 +0900, Michael Glaesemann
<[E
Michael,
That's an excellent solution, but on my table, the explain plan sucks
and the query time is over 3 minutes when implemented. Is there a
simple way to get a row_num without using a temporary sequence?
Thanks for your help.
-Don
Make your query a set returning function which iterates over
