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