May 15, 2008 at 3:31 pm
How to use a created stored procedure to get the records of a tempporary table and those records containing the constant value(unique G) in a point table.
May 16, 2008 at 1:03 am
Hi ;
I did not understand the question clearly. Please can you explain it with a sample.
May 16, 2008 at 6:19 am
From this and you other question I do not think you understand temporary tables. Temporary tables disappear when they go out of scope. Although you can create a stored procedure that pulls data from a temporary table that the procedure did not create, the procedure would have to be called from the connection that created the temporary table while the table is still in scope. There are also global temporary tables that multiple processes can access, but they too go out of scope when the connection that created them is closed.
Perhaps you should post what you are actually trying to do, by your questions, your overall approach is a bit suspect.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply