insert hard coding some columns and from a select

Question

User496086301 posted

how do we do this 

insert into TABLE1 values(id,startdate(9/8/16),enddate(12/31/9999),value,desc)

select id,value,desc from table2.

TIA

Answer 1

User-967720686 posted

Hi, 

I Think you want this. 

insert into Table1 (id, startdate, enddate, value,[desc])
select id,'9/8/2016', '12/31/2199', value,[desc] From Table2

Answer 2

User-1716253493 posted

INSERT INTO TABLE1 ([tb2_id],[startdate],[enddate],[value],[desc])
SELECT [id],@startdate,@enddate,[value],[desc] FROM TABLE2

Answer 3

User-2057865890 posted

Hi sushsudh,

SQL INSERT INTO SELECT Syntax

INSERT tbl_A (col, col2)  
SELECT col, col2   
FROM tbl_B

all columns from one table to another existing table

INSERT INTO table2
SELECT * FROM table1;

copy only the columns we want to into another existing table

INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;

reference:

http://www.w3schools.com/sql/sql_insert_into_select.asp 

Best Regards,

Chris

Answer 4

User-1404113929 posted

hi,

insert into Table1 (id, startdate, enddate, value,desc)
select id,'9/8/2016', '12/31/2199', value,desc From Table2

Thanks,

Murali