How to insert a copy row with some different values into SQL Server

Question

I need to insert a new row into the claim table. I have tried many other ways but non of them work. What I have now is

 INSERT INTO claimant_type
    SELECT ('3' 
            , col1
            , '18'
            , 'ility'
            , col4
            , col5
            , col6)
    FROM claim
    WHERE col4 = '8'

When I execute this script, it said ---- Incorrect syntax near ','. which is '3' or col1.

@DineshReddy: "... it said ---- Incorrect syntax near ','. which is '3' or col1." — Tim Schmelter
– Tim Schmelter, Commented Sep 29, 2014 at 14:31

Gordon Linoff · Accepted Answer · 2014-09-29 14:30:14Z

3

The only obvious problem is the parentheses. You don't want to put them around a select list:

INSERT INTO claimant_type
    SELECT '3' 
            , col1
            , '18'
            , 'ility'
            , col4
            , col5
            , col6
    FROM claim
    WHERE col4 = '8';

I would also recommend that you explicitly list the columns when using insert.

answered Sep 29, 2014 at 14:30

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

How to insert a copy row with some different values into SQL Server

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