inserting multiple rows into SQL

Question

I'm trying to insert lots of rows into a 2 column table at once where one of the values remains constant. This is what I have tried: -

insert into testtable (value1,value2) 
    select 
      123,
      ( SELECT [title] FROM [dbo].[images])

This gives me the following error:

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

I could insert each row one at a time but I was wondering if there is a way I g=could do the whole lot in one go.

MaxiWheat · Accepted Answer · 2014-09-23 13:38:35Z

3

You have a syntax error, do not put two SELECT in there :

INSERT INTO testtable (value1,value2) 
SELECT 123, [title] 
FROM [dbo].[images];

answered Sep 23, 2014 at 13:38

MaxiWheat

6,2497 gold badges53 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

inserting multiple rows into SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related