In our database, we generate statistics by periodically calling a large number of stored procedures in the event.
Considering there are two SP
Is there a conflict when using the same temporary table name (lets say
temp1)in both stored procedures?
I checked Q&A on Stack Overflow, they say the temporary table's scope is the current session. I think it means when we connect the db server with clients.
But in my case all the sp are running on the server side. So could anyone explain this?
Will the temporary table be automatically destroyed after one SP is finished? What if two SPs are running at the same time? Aren't they running in the same session?