SQL Insert statement for multiple values

Question

I am little confused whether we can accomplish inserting multiple rows / multiple values for few same values. To make it less complicated my table should look as shown below. Right now i have data in excel.

enter image description here

I would like to insert SET_VALUE by keeping other row values being the same. The only other option i can think of is inserting multiple times :(

INSERT INTO TABLE_NAME
  VALUES ( null, 100, 'miscellaneous', 'book', CURRENT_TIMESTAMP );

Do you want to change the current values or actually create new rows? — user330315
– user330315, Commented Feb 13, 2013 at 15:53
i have data from excel which i need to insert into table, actually insert new rows. — Mad-D
– Mad-D, Commented Feb 13, 2013 at 15:55

zimdanen · Accepted Answer · 2013-02-13 15:51:34Z

1

Look into inserting with a SELECT:

INSERT INTO TABLE_NAMES (col1, col2, changingCol, col4)
SELECT
    ConstantValue1,
    ConstantValue2,
    MyChangingValue,
    ConstantValue4
FROM
   ...

answered Feb 13, 2013 at 15:51

zimdanen

5,6367 gold badges47 silver badges96 bronze badges

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

Comments

Oleksandr Fedorenko · Accepted Answer · 2013-02-13 17:12:18Z

1

You can use OPENROWSET command. More examples to show some of the flexibility with the OPENROWSET command

let's assume that an ID IDENTITY

INSERT TABLE_NAME(SET_ID, SET_NAME, SET_VALUE, LOGIN_TIME)
SELECT 100, 'miscellaneous', SET_VALUE, CURRENT_TIMESTAMP 
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
                'Excel 8.0;Database = C:\OPENROWSET_Examples.xls;', 
                'SELECT SET_VALUE FROM [INSERT_Example$]') 
GO

edited Feb 13, 2013 at 17:12

answered Feb 13, 2013 at 17:01

Oleksandr Fedorenko

17k6 gold badges43 silver badges51 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:12:31Z

-1

Try this link

QUOTE

UPDATE a
  SET a.CalculatedColumn = b.[Calculated Column]
  FROM Table1 AS a
  INNER JOIN Table2 AS b
  ON a.CommonField = b.[Common Field]
  WHERE a.BatchNo = '110';

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Feb 13, 2013 at 15:54

Sandip Bantawa

2,9004 gold badges35 silver badges48 bronze badges

3 Comments

Sandip Bantawa Over a year ago

I would like to insert SET_VALUE by keeping other row values being the same ------ I think he wants an update

C.O.D.E Over a year ago

On one of his comments, he says "i have data from excel which i need to insert into table, actually insert new rows". So he wants to insert them.

Sandip Bantawa Over a year ago

so he is having dynamic requirements :-)

Collectives™ on Stack Overflow

SQL Insert statement for multiple values

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related