i have created a SP to create a temp table
but i just read across as
, but the temporary table exists only for the duration of the stored procedure that creates it. When the procedure completes, Adaptive Server automatically drops the temporary table.
but i want the temp table to exists till the user click a button
does it mean i need to create the #temptable in front end?
or any other way