Temp table(#): Will live in memory until user is active or connectedGlobal Temp table(##): Will live in memory until all users are connected to SQL Server.