An error message is prompted when SQL Server deletes all null rows!

Each time you import an Excel table to the database, several more rows are displayed as 'null' rows. The following prompt is displayed when you delete the table.

"The key column information is insufficient or incorrect. Update affects multiple rows! "

Solution: You can see from your description that you have imported data from Excel to SQL Server. The imported table does not have a primary key column, and all columns in multiple rows are null. When deleting this branch,The key column information is insufficient or incorrect. Update affects multiple rows". If my understanding is incorrect, please submit it.

When deleting a row, this error occurs if the row cannot be determined to be unique.

We recommend that you manually add a primary key column for the table so that each row is unique and will not encounter this error again when you delete the table again.

Other solutions: If the enterprise manager does not have a unique column and the Division data row has a duplicate column, there will be situations that cannot be eliminated.

When null exists, the processing method is as follows: copy the Excel Data to the Event Book, convert the Excel format to the text format, and then paste the data into the Excel file.

Null is displayed. It is usually caused by a column of characters, numbers, and only numbers.