SQL Server Performance

Differences between tables ## and #

Discussion in 'Getting Started' started by Trev256, Nov 20, 2007.

  1. Trev256 New Member

    What are the differences between tables that start with ## anf # ?
    Thanks
  2. FrankKalis Moderator

    [quote user="Trev256"]
    What are the differences between tables that start with ## anf # ?
    Thanks
    [/quote]
    A double ## denotes a global temp table, which is visible to all connections, while a single # is visible just to current connection and therefore is a local temp table.

Share This Page