Post reply

temporary table question

  • October 3, 2012 at 3:38 am

    #268739

    Hi

    If I have webpage and it hits a stored procedure, which uses temporary tables…

    If people are simultaneously hitting the stored procedure, is there a danger of the temporary tables getting confused

    I suppose what I mean is…are the temporary table names siloed for each web session? Or is there a change of one person hitting another's temporary table and getting other results

    regards

    DV

  • October 3, 2012 at 3:47 am

    #1544759

    I think the answer to my question of temp table scope is...

    there's no cross over if the table begins with #

    but global temp tables beginning with ## exceed the session

    and persistent TempDB. tables certainly do until the temp DB is cleared down

  • October 3, 2012 at 3:58 am

    #1544770

    Hi,

    Please go through this url, which explains each and everything in depth.

    http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

    Regards

  • October 3, 2012 at 8:17 am

    #1544948

    many thanks, it's there cheers

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply