Inserting data into a temporary table

Question

After having created a temporary table and declaring the data types like so  CREATE TABLE  TempTable  ID int  Date datetime  Name char 20    How do I then insert the relevant data which is already held on a physical table within the database

User · Answer

insert into  temptable  col1  col2  col3  select col1  col2  col3 from othertable   Note that this is considered poor practice   insert into  temptable  select col1  col2  col3 from othertable   If the definition of the temp table were to change  the code could fail at runtime

User · Answer

After you create the temp table you would just do a normal INSERT INTO    SELECT FROM  INSERT INTO  TempTable  id  Date  Name  SELECT t id  t Date  t Name FROM yourTable t

User · Answer

I have provided two approaches to solve the same issue       Solution 1  This approach includes 2 steps  first create a temporary table with   specified data type  next insert the value from the existing data   table    CREATE TABLE  TempStudent tempID  int  tempName  varchar MAX    INSERT INTO  TempStudent tempID  tempName  SELECT id  studName FROM students where id  1  SELECT   FROM  TempStudent      Solution 2  This approach is simple  where you can directly insert the values to   temporary table  where automatically the system take care of creating   the temp table with the same data type of original table    SELECT id  studName  INTO  TempStudent FROM students where id  1  SELECT   FROM  TempStudent

User · Answer

INSERT INTO  TempTable ID  Date  Name  SELECT OtherID  OtherDate  OtherName FROM PhysicalTable

User · Answer

My way of Insert in SQL Server  Also I usually check if a temporary table exists   IF OBJECT ID  tempdb   MyTable   IS NOT NULL DROP Table  MyTable  SELECT b Val as  bVals    INTO  MyTable FROM OtherTable as b

User · Answer

The right query   drop table  tmp table  select new acc no  count new acc no  as count1 into  tmp table from table where unit id    0007   group by unit id  new acc no having count new acc no   gt  1

User · Answer

SELECT    INTO  TempTable FROM table

User · Answer

All the above mentioned answers will almost fullfill the purpose  However  You need to drop the temp table after all the operation on it  You can follow- INSERT INTO  TempTable  ID  Date  Name   SELECT id  date  name  FROM physical table   IF OBJECT ID  tempdb dbo  TempTable   IS NOT NULL      DROP TABLE  TempTable

User · Answer

SELECT  ID   Date   Name into  temp from  TableName

User · Answer

Basic operation of Temporary table is given below  modify and use as per your requirements    -- CREATE A TEMP TABLE  CREATE TABLE  MyTempEmployeeTable tempUserID  varchar MAX   tempUserName  varchar MAX      -- INSERT VALUE INTO A TEMP TABLE  INSERT INTO  MyTempEmployeeTable tempUserID tempUserName  SELECT userid username FROM users where userid  21   -- QUERY A TEMP TABLE  This will work only in same session Instance  not in other user session instance   SELECT   FROM  MyTempEmployeeTable   -- DELETE VALUE IN TEMP TABLE  DELETE FROM  MyTempEmployeeTable   -- DROP A TEMP TABLE  DROP TABLE  MyTempEmployeeTable

User · Answer

To insert all data from all columns  just use this   SELECT   INTO  TempTable FROM OriginalTable   Don t forget to DROP the temporary table after you have finished with it and before you try creating it again   DROP TABLE  TempTable

User · Answer

All the above mentioned answers will almost fullfill the purpose  However  You need to drop the temp table after all the operation on it  You can follow- INSERT INTO  TempTable  ID  Date  Name  SELECT id  date  name FROM physical table  IF OBJECT ID  tempdb dbo  TempTable   IS NOT NULL DROP TABLE  TempTable

User · Answer

INSERT INTO  TempTable  ID  Date  Name   SELECT id  date  name  FROM physical table

User · Answer

insert  temptable select idfield  datefield  namefield from yourrealtable

[sql] Inserting data into a temporary table

Examples related to sql

Examples related to sql-server

Examples related to temp-tables