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:

• SQL Server questions for interview

• Overview of Sql

• Sql server while loop

• Continue Statement in sql

• SQL Parameter how to use in asp.net

• SQL-QUERY TYPES, ALIASES, JOINS, CLAUSES, FUNCTIONS

• Sql-determine the version and edition of SQL Server

• Sql -Stored procedure how to use

• Different Types of SQL Server Stored Procedures

• SQL-Create Stored Procedure in SQL Server:

• SQL Server -Create Stored Procedure with Parameter

• How to Create Sql Function,

• SQLInjection, prevent asp.net web application

• SQL Server- Database Backup and Restore History

• SQL Server -Create Stored Procedure with Parameter

• Sql server cursor declaration syntax example

• Sql server –Example of sql cursor with syntax

• Drop all Triggers belonging to any schema in SQL Server.

• SQL Server - Copy data from one database to another data base.

• SQL Server bulk copy and bulk import and export techniques