Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Friday, February 5, 2016

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:


No comments:

Post a Comment