Error executing multiple insert statements , Major Error 0x80040E14

SQL Compact - Error executing multiple insert statements:



Error executing multiple insert statements:


Major Error 0x80040E14, Minor Error 25501:


You could also consider using one single statement, and separating the individual values with commas. This works in regular SQL Server. I'm not sure if it also works on Compact, as I don't have that installed, but I see no reason why it shouldn't:

INSERT INTO TableName
                                   (Cname,CName)
VALUES
                               ('Value’), ('value')




                                          or

INSERT INTO TableName(col1,col2,)values(val1,val2)



Sql Server Interview Qus:


Comments