SQL Compact - Error executing multiple insert statements

sql, sql-server, sql-server-ce

Solution

Put GO between them. I think SQL CE doesn't handle batches.

Problem

I'm using management studio to connect to my sql mobile/compact database. I'm trying to insert some dummy data into some tables, for example: ``` INSERT INTO FlooringTypes (FlooringType) VALUES ('Carpet') INSERT INTO FlooringTypes (FlooringType) VALUES ('Smooth') ``` However it returns the error: Major Error 0x80040E14, Minor Error 25501 If I run them seperately it works fine.

Original source