Syntax to insert more than one row in table

[ashark]

Hi Group,
I wnat to insert more than one row in table.
Can you please tell me how that can be done in one SQL statement

Thankyou.
ashark

 

[swampBoogie]

insert into t(c1,c2)
select 1,2
union
select 2,3

 

[ashark]

Hi swampBoogie,
Do you want to say that :
INSERT INTO Table (PriKey, Description)
VALUES (123, 'A description of part 123.')
union
VALUES (124, 'A description of part 124.')

 

[swampBoogie]

No, I want to say what I said.

 

[ashark]

can you please explain me how you insert multiple rows in a single SQL statement.

 

[sunila7]

Hi,

What swampboogie has suggested should work. If that is not wht u want, please give an example of wht u r trying to accomplish.

Sunil

 

[SQLSister]

Try:

INSERT INTO Table (PriKey, Description)
Select 123, 'A description of part 123.'
union
Select 124, 'A description of part 124.'

Of course if your PriKey is an identity field you wouldn;t put it in the insert! Then try:

INSERT INTO Table (Description)
Select 'A description of part 123.'
union
Select 'A description of part 124.'