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# 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).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment