--**************************************
--
-- Name: Deleting Duplicate Rows
-- Description:The Purpose of this code
-- is to delete the duplicate values occuri
-- ng in a table. This code is column-orien
-- ted. That means the code works for the d
-- uplicate values occuring in a specified
-- column and deletes the values of the row
-- s corresponding to that column.
-- By: barkýn ünüulu
--
-- Inputs:I am going to specify the colu
-- mn name as COLUMNNAME and table name as
-- TABLENAME. It should be noted that the d
-- evelopers that are willing to run this c
-- ode should put an "id" column in to thei
-- r tables, which increments automatically
-- .
--
-- Side Effects:As the row number increa
-- ses, the time elapsed for the code incre
-- ases...
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/vb/scripts/Sh
-- owCode.asp?txtCodeId=936&lngWId=5--for details.--**************************************
--
DECLARE @i int
DECLARE @j int
DECLARE @k int
SET @k=(select count(*) FROM TABLENAME)
SET @i=1
WHILE @i<=@k
BEGIN
SET @j=@i+1
WHILE @j<=@k
BEGIN
IF ((select COLUMNNAME FROM TABLENAME WHERE ID=@i)=
(select COLUMNNAME FROM TABLENAME WHERE ID=@j))
begin
DELETE FROM TABLENAME
WHERE ID=@j
end
SET @j=@j+1
end
SET @i=@i+1
END
Deleting Duplicate Rows
最新推荐文章于 2022-02-25 21:57:21 发布