Monday, 28 January 2013

SQL : Inserting multiple rows using onq sql query

Following SQL query is used to insert multiple record into table

INSERT INTO tmpTable (field1, field2,field3) VALUES
 ('74251', 'Black', '511black')
INSERT INTO tmpTable  (field1, field2,field3) VALUES
 ('74251', 'CharcoalF', '5145')
INSERT INTO tmpTable  (field1, field2,field3) VALUES
 ('74251', 'KhakiQ', '5165')
INSERT INTO tmpTable  (field1, field2,field3) VALUES
 ('74251', 'NavyA', '515')
INSERT INTO tmpTable  (field1, field2,field3) VALUES
 ('74251', 'OD', '511')

No comments:

Post a Comment