temp-tables Questions
3
Solved
I work on postgres database where I'll using a mix of relational tables and jsonb tables (which can be indexed).
I have being using a lot of CTE queries to insert or update data selecting from a t...
Zippora asked 28/5, 2015 at 19:25
3
It seems like the biggest drawback with SQLAlchemy is that it takes several steps backwards when it comes to working with temporary tables. A very common use case, for example, is to create a tempo...
Croydon asked 20/1, 2016 at 1:24
5
I have a client application that creates a temp table, the performs a bulk insert into the temp table, then executes some SQL using the table before deleting it.
Pseudo-code:
open connection
begi...
Cnidoblast asked 15/4, 2010 at 1:13
3
Solved
I am trying to use use a temp table with SQLAlchemy and join it against an existing table. This is what I have so far
engine = db.get_engine(db.app, 'MY_DATABASE')
df = pd.DataFrame({"id": [1, 2, ...
Menhaden asked 23/5, 2017 at 16:44
3
Solved
How to insert the resultset given by the commands
RESTORE FILELISTONLY
RESTORE HEADERONLY
RESTORE VERIFYONLY
into an automatically generated temp table ?
I would like to use a technique similar...
Mood asked 5/8, 2010 at 9:21
4
Solved
I am trying to execute two select statements into a query that pumps data into a temp table. The first query will have 5 columns while the second query will have only one column.
The first can be ...
Dogooder asked 7/1, 2014 at 9:18
6
Solved
This seems relatively simple, but apparently it's not.
I need to create a temp table based on an existing table via the select into syntax:
SELECT * INTO #TEMPTABLE FROM EXISTING_TABLE
The prob...
Constringe asked 2/3, 2012 at 14:33
5
Solved
I would like to create a temporary table in a Oracle database
something like
Declare table @table (int id)
In SQL server
And then populate it with a select statement
Is it possible?
Thanks
...
Doradorado asked 19/4, 2010 at 23:9
9
Solved
I just want a quick way (and preferably not using a while loop)of createing a table of every date between date @x and date @y so I can left outer join to some stats tables, some of which will have ...
Nath asked 18/9, 2008 at 18:21
3
Solved
what are the main purposes for which temporary tables are used? I want to know the practical and commercial uses of temporary tables in actual softwares working in small and large scale companies.
...
Fort asked 12/2, 2011 at 5:47
10
Solved
Was trying to select...into a temp Table #TempTable in sp_Executedsql.
Not its successfully inserted or not but there Messages there written
(359 row(s) affected) that mean successful inserted?
Sc...
Flurry asked 7/11, 2011 at 17:22
2
I'm looking to create a temp table and insert a some data into it. I have used pyodbc extensively to pull data but I am not familiar with writing data to SQL from a python environment. I am doing t...
Marylandmarylee asked 22/8, 2019 at 19:2
6
Solved
I have the following issue in SQL Server, I have some code that looks like this:
DROP TABLE #TMPGUARDIAN
CREATE TABLE #TMPGUARDIAN(
LAST_NAME NVARCHAR(30),
FRST_NAME NVARCHAR(30))
SELECT LAST_NA...
Kahler asked 19/8, 2013 at 19:7
5
We have a simple "crm-like" software in our company. There are some complex queries that were taking some time, daily-use queries... so i am testing some modifications to use Temporary Tables to re...
Babbette asked 17/8, 2011 at 12:24
4
Solved
I am using pgAdmin for my Postgres 8.4 database and I was wondering where (any table/schema/etc. ?) may I find a list of currently used temporary tables? I assume there has to be a place where I ca...
Tomfool asked 4/4, 2011 at 9:34
2
Solved
Goal
Invoke a CREATE TEMPORARY TABLE statement in Hibernate without using native SQL. That means using HQL or Hibernate APIs only.
Save objects to the temporary table.
Invoke a stored procedure w...
Embay asked 19/7, 2010 at 3:1
16
Solved
I have query in a stored procedure that calls some linked servers with some dynamic SQL. I understand that EF doesn't like that, so I specifically listed all the columns that would be returned. Yet...
Larcher asked 20/8, 2011 at 0:35
2
Solved
Hi I am creating a temp table and insert a record using
CREATE TEMPORARY TABLE temp_table_extension_details (
`Id` int NOT NULL,
`model_code` varchar(10),
`model_description` varchar(50),
`et...
Lykins asked 16/7, 2015 at 2:18
4
Solved
Does SQL server automatically purge these out after a given length of inactivity or do I need to worry about purging them automatically? If so, how do I query for a list of tables to purge?
Guitarfish asked 27/3, 2009 at 4:14
13
Solved
In SQL Server 2005, we can create similar tables in two different ways.
We can use a table variable:
declare @tmp table (Col1 int, Col2 int);
Or we can use a temporary table:
create table #tmp (Co...
Tracay asked 26/8, 2008 at 12:27
3
Solved
In SQL Server stored procedures when to use temporary tables and when to use cursors. which is the best option performance wise?
Flathead asked 31/12, 2010 at 6:11
4
If you create temp tables using "insert into" in SQL Server it uses the first insert to determine whether a column accepts null value or not. if the first insert has null value the column become nu...
Savonarola asked 7/3, 2013 at 6:34
8
Solved
Is there any SQL subquery syntax that lets you define, literally, a temporary table?
For example, something like
SELECT
MAX(count) AS max,
COUNT(*) AS count
FROM
(
(1 AS id, 7 AS count),
(2,...
Champaign asked 12/6, 2009 at 6:41
6
Solved
Is it possible to create a temporary (session only) table from a select statement without using a create table statement and specifying each column type? I know derived tables are capable of this, ...
Subglacial asked 2/5, 2011 at 16:3
24
Solved
It appears that MySQL doesn't have array variables. What should I use instead?
There seem to be two alternatives suggested: A set-type scalar and temporary tables. The question I linked to sugg...
Shiller asked 29/8, 2012 at 11:18
1 Next >
© 2022 - 2025 — McMap. All rights reserved.