Top "Temp-tables" questions

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

sp_send_dbmail will not send query results

I've tried every avenue on every damn forum suggested, but to no avail! Need to send results of SQLPERF(logspace), …

sql-server temp-tables sp-send-dbmail
Default collation of temporary tables

How can I check what the collation of a temporary table is? I want to do this because I want …

sql sql-server tsql collation temp-tables
CTE and temporary index on PostgreSQL

I work on postgres database where I'll using a mix of relational tables and jsonb tables (which can be indexed). …

postgresql temp-tables postgresql-9.4 jsonb
SAP HANA : How to insert the result of stored procedure into local temporary table

I am trying to store the result of my read/write stored procedure in local temporary table. After creating the …

stored-procedures temp-tables hana-sql-script
CTE,Temp table and table variable

Can any one please tell me where to use CTE, temp table and table variable? I read about their differences …

common-table-expression sql-server-2014 temp-tables table-variable
What is the difference between TEMPORARY TABLE and TABLE VARIABLE in SQL 2008?

What is the difference between: CREATE TABLE #temp ( [ID] INT) INSERT INTO #temp SELECT ... and DECLARE @temp TABLE ( [ID] INT) …

sql sql-server sql-server-2008 tsql temp-tables
Is it a best practice to drop the temp table after using it, in addition to before creating the temp table?

I have a stored proc that creates a temp table. It is only needed for the scope of this stored …

sql-server temp-tables sql-server-2014
How to access dataset in current scope generated by a call to a stored procedure in TSQL?

Problem Background Generating and accessing data of a fixed column layout is easy. You can create local temp tables up-front, …

tsql scope dynamic-data temp-tables
get the columns of a Temp table in sybase

Is there a way to get the list of columns of a temporary table in sybase? suppose I have a …

sql sybase temp-tables
Table doesn't exist After Creating a Temp Table

Hi I am creating a temp table and insert a record using CREATE TEMPORARY TABLE temp_table_extension_details ( `Id` …

mysql phpmyadmin temp-tables