Query on Temporary table

• RockingAdmin

  SSCrazy

  Points: 2828

  More actions

  January 11, 2010 at 7:07 am

  #215477

  Hi,

  i have created some stored procedures in the sql server 2005 database for the application requirement. i have created temporary tables in the stored procedures with same name like #temp.many users can access the application, application can run stored procedures at same time based on user requirement.is there will be any issue using with same temporary table name?

  Thank in advance

  Rock..

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  January 11, 2010 at 7:12 am

  #1101762

  No issue at all. Each session will have its own unique version of the table.

  ---

  
  Clear Sky SQL
  My Blog[/url]