SQL Compact - Error executing multiple insert statements

Question

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.

Answer 1

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

Answer 2

The first will work by adding a semi colon after each line (excluding the last line).

INSERT INTO FlooringTypes (FlooringType) VALUES ('Carpet');   
INSERT INTO FlooringTypes (FlooringType) VALUES ('Smooth')