Passing Variable to SQL insert statement

Question

I know this code here selects columns from one table and inserts it into another table. However, I have a value that I want to insert into one of the columns, how do I pass in the value?

This selects from on table and inserts into another...

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

However, I want column1 to have a value that I set above the code e.g MY_NAME varchar(20)

set @MY_NAME = "Helen"

Then my insert statement to be something like this:

INSERT INTO table2 (column1, column2, column3, ...)
SELECT *@MY_NAME*, column2, column3, ...
FROM table1
WHERE condition;

Any help would be appreciated.

@MalwareWerewolf I'm using SQL Server, sorry forgot to mention it — Helen Neely
– Helen Neely, Commented Jan 6, 2022 at 19:20

Malware Werewolf · Accepted Answer · 2022-01-06 19:26:38Z

1

To achieve that you should do something like this:

declare @MY_NAME AS varchar(20)
set @MY_NAME = 'Helen'

Insert into table2([column1], [column2], [column3]) 
select @MY_NAME, column2, column3  
from table1

answered Jan 6, 2022 at 19:26

Malware Werewolf

3531 silver badge9 bronze badges

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

3 Comments

Helen Neely Over a year ago

Thanks, will try it in the morning, just leaving the office now. Will report back in the morning.

Helen Neely Over a year ago

Thanks, this worked like a charm - exactly what I was looking for. :)

Malware Werewolf Over a year ago

I’m glad that worked ;)

Collectives™ on Stack Overflow

Passing Variable to SQL insert statement

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related