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