Press "Enter" to skip to content

Local and Global Temp Tables

Chad Callihan compares local versus global temp tables:

Have you ever noticed a temp table with not one but two pound signs in front? Let’s take a look at the differences between ##Temp and #Temp.

Global temp tables have some interesting properties to them, especially when they’re combined with linked servers. “Interesting” here probably means “evil” but sometimes, we are the baddies.