• Since you mention temp tables #temp (local to connection), you should also mention global temp tables ##temp (accessible by all connections).

    Also, how to check it the temp table exists.

    Best practice is to first discuss a topic and then write the article.

    Such article is then more accurate, informative and an excellent reference to point newbies to.