Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003

    Unanswered: # vs ## (beginner question)

    Newbie question here. Could someone tell me what difference prefixing a table with # vs. ## is? Is there a difference? Does this signify anything?

    Thanks, Matt

  2. #2
    Join Date
    Mar 2003
    # means a local temp table, only available to you, ## means a global temp table, available to other connections too.

    That may not be 100% right, but I think that's basically it.

    If you need global and you specify local, you will probably notice at some point, since only 1 user at a time ever be able to use it. If you need local and specify global, you will probably only ever notice if you get a name clash (global temp tables must have unique names).

Posting Permissions

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