Search code examples
sqlsql-serversql-server-ce

SQL Compact - Error executing multiple insert statements

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.

Solution

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