Top "Temp-tables" questions

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

How to create temporary tables in Hibernate?

Goal Invoke a CREATE TEMPORARY TABLE statement in Hibernate without using native SQL. That means using HQL or Hibernate APIs …

stored-procedures transactions temp-tables database-versioning hibernate
Clustered index on temp table

I'm trying to optimize a procedure that has code like the following: CREATE TABLE #t1 (c1 int, c2 varchar(20), c3(…

sql sql-server tsql temp-tables clustered-index
DBCC CHECKIDENT on a temporary table throwing permissions error for wrong user

I'm logged into a SQL Server 2005 database as a non-sa user, 'bhk', that is a member of the 'public' server …

sql-server-2005 stored-procedures permissions temp-tables
is a mysql temporary table unique for each user accessing the script that creates it...?

While looking for a way to temporarily save the search results when a user searches for a hotel free between …

mysql temp-tables
Why are temporary tables faster than table variables for joins?

Why are temporary tables faster than table variables for joins in SQL Server? NOTE: In both scenarios the tables have …

sql-server join table-variable temp-tables
Temporary table in pgAdmin

I am using pgAdmin for my Postgres 8.4 database and I was wondering where (any table/schema/etc. ?) may I find …

postgresql temp-tables pgadmin
Table variable poor performance on insert in SQL Server Stored Procedure

We are experiencing performance problems using a table variable in a Stored Procedure. Here is what actually happens : DECLARE @tblTemp …

sql-server stored-procedures temp-tables table-variable
How to insert into a temp table the info given by RESTORE FILELISTONLY / HEADERONLY / VERIFYONLY

How to insert the resultset given by the commands RESTORE FILELISTONLY RESTORE HEADERONLY RESTORE VERIFYONLY into an automatically generated temp …

sql-server sql-server-2008 temp-tables database-restore
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 …

tsql temp-tables sp-executesql global-temp-tables
Scope of temp tables created in MySQL stored procedure

QUESTION WITHDRAWN! When I spell everything correctly, the problem goes away! I have a MySQL stored procedure which creates a …

mysql stored-procedures temp-tables