SQL Insert with Select and Parameter

Question

Hello I have a problem

declare @target_date datetime
set @target_date=GETDATE();


insert into table1 ([column1],[column2],[column3])
(select [column1],[column2] from table2 where id=@id), @target_date

How can I solve this problem

Insert
Table1.Column1=Table2.Column1
Table1.Column2=Table2.Column2
Table1.Column3=@target_date

Matt · Accepted Answer · 2016-11-14 17:38:02Z

4

declare @target_date datetime
set @target_date=GETDATE();


insert into table1 ([column1],[column2],[column3])
select [column1],[column2], @target_date from table2 where id=@id

Just make the variable the value of a calculated column

answered Nov 14, 2016 at 17:38

Matt

14.4k2 gold badges19 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Karvan · Accepted Answer · 2016-11-14 17:40:55Z

0

you don't need () for select command after insert, and you have to move @target_date inside the select command.

answered Nov 14, 2016 at 17:40

Karvan

2602 silver badges7 bronze badges

1 Comment

Matt Over a year ago

Technically you would be correct, though I have already answered that way. It would be good in the future to show the actual change via code rather than a straight narrative it is easier for others to follow your answer that way.

Collectives™ on Stack Overflow

SQL Insert with Select and Parameter

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related