Top "Select-into" questions

There is already an object named 'tbltable1' in the database

I am trying to insert data from one table to another with same structure, select * into tbltable1 from tbltable1_Link …

sql sql-server sql-server-2005 select-into
Declare row type variable in PL/pgSQL

As I found SELECT * FROM t INTO my_data; works only if: DO $$ DECLARE my_data t%ROWTYPE; BEGIN SELECT * …

postgresql types plpgsql declare select-into
Is it possible to create indexes on a temp table when using SELECT INTO?

I am loading data from a CSV file into a temp staging table and this temp table is being queried …

sql tsql indexing select-into
Building a comma-separated list of values in an Oracle SQL statement

I'm trying to build a comma-separated list of values out of a field in Oracle. I find some sample code …

oracle select-into
SQL Select Into Field

I want to accomplish something of the following: Select DISTINCT(tableA.column) INTO tableB.column FROM tableA The goal would …

sql distinct select-into
add extra columns in a SELECT INTO statement

I am doing a SELECT INTO statement to create a new table from some values in another table. I want …

sql tsql datetime select select-into
Select Into Explanation / Temporary Tables

Based on the tutorial on SQL Temporary Tables, it should be OK to create a temp table by using SELECT * …

c# sql temp-tables select-into
SQL SELECT INTO query with a Join, Error "There is already an object named '*****' in the database."

I'm currently trying to copy data from table into another by using a SELECT INTO query. But Im receiving an …

sql sql-server join select-into
PL/pgSQL: Can we store a query result into a variable

I'm trying to create a function in plpgsql like: CREATE OR REPLACE FUNCTION select_left_photo_ids(in_photo_id …

postgresql stored-procedures plpgsql select-into
Unable to 'SELECT INTO' when value doesn't exist

SELECT Value1 INTO lValue FROM Table1 WHERE Field1 = lTempValue; This works fine when the match is true. But if the …

oracle plsql package select-into