Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to delete duplicate records in the data table in Sql Server. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

1, generate a temporary table new_users, table structure is the same as the users table; 2, the users table according to id to do a cycle, each read out a record from the users table to determine whether there is the same u_name in the new_users, if not, then insert it into the new table; if there is the same entry, then ignore this record; 3, change the users table to another name, rename the new_users table to users, to achieve our needs.

[program] the copy code is as follows: declare @ id int,@u_name varchar (50), @ u_pwd varchar (50) set @ id=1

While @ id

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.