insert into tablename (col1,col2) values('abc','qwe'); insert into tablename (col1,col2) values('def','hkg');
INSERT INTO MyTable (FirstCol, SecondCol) VALUES ('First',1), ('Second',2), ('Third',3), ('Fourth',4), ('Fifth',5)
INSERT INTO myTable ([name], [date]) VALUES ('Joe', 2011-04-02), ('Joe', 2011-04-03), ('Joe', 2011-04-04), ('Joe', 2011-04-05)
INSERT INTO myTable ([name], [date]) SELECT 'Aneesh','01/01/2010' SELECT 'Ajith','01/01/2006'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)