Skip to Content
0
Apr 24, 2014 at 07:52 AM

MULTIPLE INSERTS IN A SINGLE SQL Query template

1931 Views

HI Experts,

I want to insert multiple records in a single SQL statement in a MII query template

I tried using

INSERT INTO TABLE (ID, Value)
VALUES (1, 'First'), (2, 'Second'), (3, 'Third')

But its not working out for me

Writing multiple insert statement is also an option but i want to write single insert statement and values separated by comma

Could any one kindly tell me how to insert multiple records in a single line with values separted by a comma

Thanks

Praveen