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

In order to solve the problem of how to remove duplicate data in sql2000 database, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Using cursors to implement

Declare @ id1 int,@oldid int,@e_REcordid int,@ Olde_REcordid intDECLARE price CURSORFOR SELECT id, E_recordId FROM evaeve order by E_recordId descOPEN priceFETCH NEXT FROM price into @ oldid,@Olde_REcordidwhile @ @ fetch_status = 0beginFETCH NEXT FROM price into @ id1,@e_REcordid

If @ Olde_REcordid=@e_REcordidBEGIN delete from evaeve where id=@id1end set @ oldid=@id1set @ Olde_REcordid=@e_REcordidend close price DEALLOCATE price

Using SQL statements to implement

Delete from evaeve where id not in (select max (id) from evaeve group by E_RecordID)

This is the answer to the question about how to remove duplicate data in the sql2000 database. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.