"SQL Server" Problem collection removes identical records from the same table

1 overview

In SQL Server, when you delete two identical records from the same table through SQL Server Designer, the following prompt pops up:

Click "Yes"

Pop up the following prompt, do not let delete

2 Problem Solving

This is a simple question, delete it with a DELETE statement.

If you clear all the data in the table

DELETE  EmployeeInfo

If you just delete the same record

DELETE  WHERE employyeid = ' NX001 '  

3 Copyrights

• Thank you for your reading, if there are shortcomings, welcome advice, common learning and common progress.
• Bo main website: http://www.cnblogs.com/wangjiming/.
• A very small number of articles using reading, reference, reference, copying, copying and pasting into a variety of ways, most of the original.
• If you like, please recommend, if you have new ideas, welcome, email: [Email protected].
• The blog can be reproduced, but must be well-known from the blog source.

"SQL Server" Problem collection removes identical records from the same table