How do I execute multiple insert statements in a single call? I've tried several variations and I just get a host of various errors indicating I don't know what I'm doing.
I've stripped down my command to the most basic, just tell me what I need for 2 and I can get that repeated.
INSERT INTO MyTable (MyColumn) VALUES (1)
INSERT INTO MyTable (MyColumn) VALUES (2)
I am pretty sure I am just missing a command separator or some command to indicate it is multiple statements (or both).