Can you briefly explain the difference between ##temp and #temp?

quote:

---

Have you used ##temptable or #temptable? - it would make a difference for...

well, i'll be a monkeys uncle. I tested with temp tables (#temp) and found that they did not work within multiple procs, and with dynamic sql. (The core...

Well, I have a series of stored procedures that perform various functions, all needing access to this temporary real table. Initially I wanted to use true temp tables, but...

I love having standards spelled out. Makes everyones job that much easier, because its readable and, well, standard.

Personally, I like naming indexes differently. I will put the index...

We are creating a monitoring software. Something simple. Pretty hard coded to our objects and dbs. But as we thought about it, why not spit out more...