Temporaray tables

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: PH (PH_at_discussions.microsoft.com)
Date: 02/21/05 

Date: Mon, 21 Feb 2005 07:55:16 -0800

What is the difference between #temptables and ##temptables? I am aware that
##temptables are global temporary tables and #temptables are local. Is there
any difference apart from this? Is it true that ##temptables will get dropped
by itself when the session ends? What happens when they (##temptables) are
created within a stored procedure? Will they get dropped automatically after
the stored procedure is executed? Thanks in advance!