Top "Global-temp-tables" questions

Global temporary tables are temporary tables visible to all sessions.

Local and global temporary tables in SQL Server

What is the difference between local and global temporary tables in SQL Server?

Read More
sql-server temp-tables global-temp-tables
How to see temp table created by code in sql server?

I create a global temp table (i.e ##TheTable) using C# code. I want to be able to see that …

Read More
c# .net sql-server temp-tables global-temp-tables
INSERT INTO temporary table from sp_executsql

Generally, I am bulding dynamic SQL statement that is executing using sp_executsql like this: EXEC sp_executesql @TempSQLStatement I …

Read More
tsql temp-tables sp-executesql global-temp-tables
"ORA-14450: attempt to access a transactional temp table already in use" in a compound trigger

I have a table which can hold many records for one account: different amounts. ACCOUNTID | AMOUNT id1 | 1 id1 | 2 id2 | 3 id2 | 4 …

Read More
oracle triggers transactions distributed-transactions global-temp-tables