I'm trying to get multiple inserts to work in a single script using the SQL Compact 4.0 Toolbox and not having any luck. I keep getting a parsing error.
I've even tried adding GO; between each statement like so..
INSERT INTO ... ;
GO;
INSERT INTO ... ;
with no luck.. so am I out of luck? Do I have to just execute each statement one at a time?
Update to the latest release version (2.3). There was a bug with multiple statement execution, that has been fixed in the latest release version. Seperate each statement with GO on a separate line, no semicolon after... Like the INSERT statements created by the tool:
INSERT INTO [Shippers] ([Shipper ID],[Company Name]) VALUES (1,N'Speedy Express');
GO
INSERT INTO [Shippers] ([Shipper ID],[Company Name]) VALUES (2,N'United Package');
GO
INSERT INTO [Shippers] ([Shipper ID],[Company Name]) VALUES (3,N'Federal Shipping');
GO