Using Temp tables in .NET RRS feed

  • Question

  • Hello,


    I would like to start using Temp tables in .NET.  My concern is when the table would get removed.


    Is it removed when the connection that created it is closed, or is it when the program closes?


    Thanks for any tips,



    Thursday, April 24, 2008 3:04 AM

All replies

  • #temptable exists for the duration of the connection (session).


    You may consider using stored procedures (which may use #temptable(s)).

    Temporary tables are automatically multi-user enabled.

    Article: http://www.programmers-corner.com/article/76


    • Edited by Kalman Toth Tuesday, November 22, 2011 1:14 AM
    • Proposed as answer by Naomi N Tuesday, November 22, 2011 1:20 AM
    Thursday, April 24, 2008 9:00 AM