Top "Temp-tables" questions

Temporary tables are a feature of RDBMS's as a means of storing intermediate results.

DROP TABLE fails for temp table

I have a client application that creates a temp table, the performs a bulk insert into the temp table, then …

sql-server temp-tables sql-drop
View or Temporary Table - which to use in MS SQL Server?

I have a problem to decide whether to use a view or a temp table. I have a stored procedure …

sql sql-server view temp-tables
Where Do Temporary Tables Get stored in sql server?

Where do temporary tables get stored in a database? I want to drop a temporary table if it already exists. …

sql sql-server-2005 temp-tables
Use a temp table in a Table-valued Functions

I'm trying to use a temp table in a table-valued function, but it seems I can not. Is there any …

sql-server-2008 tsql function temp-tables
SQL Insert Into Temp Table in both If and Else Blocks

I'm trying to populate a temp table based on the result of a condition in SQL 2005. The temp table will …

sql sql-server-2005 temp-tables insert-into
SQL Performance Slow (Improve Insert Into Temp Table)

I have been working on an old auditing stored procedure that is running slowly, I have had some success from …

sql sql-server performance stored-procedures temp-tables
Force Oracle Drop Global Temp Table

In our project I create some global temp table that will be like these: CREATE GLOBAL TEMPORARY TABLE v2dtemp ( …

oracle plsql ddl temp-tables
Using row count from a temporary table in a while loop SQL Server 2008

I'm trying to create a procedure in SQL Server 2008 that inserts data from a temp table into an already existing …

sql-server sql-server-2008 while-loop temp-tables rowcount
Is it safe to put an index on an Oracle Temporary Table?

I have read that one should not analyze a temp table, as it screws up the table statistics for others. …

oracle indexing temp-tables
DECLARE GLOBAL TEMPORARY TABLE Vs CREATE GLOBAL TEMPORARY TABLE in DB2

am creating a GLOBAL TEMPORARY TABLE in DB2. and when i surfed i got a two way to create 1. Declare 2. …

performance stored-procedures db2 temp-tables