SQL Server global temp tables

Results 1 to 2 of 2

Thread: SQL Server global temp tables

  1. #1
    Join Date
    Dec 1969

    Default SQL Server global temp tables

    I have a series of stored procedures in SQL Server 7 that will need to call other stored procedures which populate global temporary tables. I am not familiar with how SQL Server handles concurrent calls to these stored procedures that populate the global temp tables. <BR><BR>Let&#039s say I call stored procedure sp_PopulateTable which populates the global temp table ##temp. If I have two concurrent calls of sp_PopulateTable, with each call passing a different parameter value (meaning sp_PopulateTable will populate ##temp with different data due to the different parameter values), will SQL Server manage this and create two instances of ##temp? Or will it lock due to concurrency problems? <BR><BR>Thanks in advance for any help or references on this.<BR><BR>Megan

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server global temp tables

    I believe it will. SQL will still take the request for a service as first come first serve. As long as you have some type of autonumber increment in the table, it shouldn&#039t be a problem.<BR><BR>Brian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts