with looking at scope of temp table, we can there are two types
1) Local temp table with name begins with single #
2) Global temp table with name begins with double ##
Also, if you need to store some data temporary, you can also use table varible.
Kindly have a look at this link for some more details.
- Chintak (My Blog)
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?