T-SQL insert into tablewith values coming from QUERY + VARIABLE

Question

I want to insert into table single record in one shot with values coming from QUERY + VARIABLE.

E.g. Insert into Table2(c1,c2,c3,c4)

c1,c2,c3 are coming from select col1,col2,col3 from Table1 c4 is coming from variable @var

As the volume of data is huge, I can not have one insert and second update.

Thanks in advance.

Andomar · Accepted Answer · 2011-01-09 21:01:25Z

2

That's a pretty straightforward insert:

insert  Table2
        (c1, c2, c3, c4)
select  col1, col2, col3, @var
from    Table1

answered Jan 9, 2011 at 21:01

Andomar

239k55 gold badges387 silver badges412 bronze badges

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

Comments

Mark Byers · Accepted Answer · 2011-01-09 21:01:12Z

2

Try this:

INSERT INTO Table2 (c1,c2,c3,c4) 
SELECT col1, col2, col3, @var FROM table1

answered Jan 9, 2011 at 21:01

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges