How to add multiple rows at a time..

[Guest joy]

Hi..can some one help me how to add multiple rows at a time.I usually do this using insert into that many times..Ex: If I have to insert two rows I do it this wayINSERT INTO tablenameVALUES(a,b,c)INSERT INTO tablenameVALUES(f,s,d)I am using sql server.Thanks in advance..

[murfitUK]

You only need to separate the new row values with a comma.INSERT INTO tablename VALUES (a, b, c), (f, s, d), (x, y, z);Don't forget to put single quotes round strings though.

[Jack McKalling]

The full syntax:

INSERT INTO tablename (column1, column2, column3)VALUES ('a1','a2','a3'), ('b1','b2','b3'), ('c1','c2','c3')