Tek Prosedür ile tablelerinizdeki gereksiz satırları silme ve Düzenleme

CREATE PROCEDURE [dbo].[dely_duzen]
AS
--Written by Dely
--Thx For Dumanlar
--+10 - +9 - +8 - +7 - +6 Takılari Silelim
delete from ITEM WHERE strName LIKE '%(+6)%' and kind = 94
delete from ITEM WHERE strName LIKE '%(+7)%' and kind = 94
delete from ITEM WHERE strName LIKE '%(+8 )%' and kind = 94
delete from ITEM WHERE strName LIKE '%(+9)%' and kind = 94
delete from ITEM WHERE strName LIKE '%(+10)%' and kind = 94
delete from ITEM WHERE strName LIKE '%(+6)%' and kind = 93
delete from ITEM WHERE strName LIKE '%(+7)%' and kind = 93
delete from ITEM WHERE strName LIKE '%(+8 )%' and kind = 93
delete from ITEM WHERE strName LIKE '%(+9)%' and kind = 93
delete from ITEM WHERE strName LIKE '%(+10)%' and kind = 93
delete from ITEM WHERE strName LIKE '%(+6)%' and kind = 91
delete from ITEM WHERE strName LIKE '%(+7)%' and kind = 91
delete from ITEM WHERE strName LIKE '%(+8 )%' and kind = 91
delete from ITEM WHERE strName LIKE '%(+9)%' and kind = 91
delete from ITEM WHERE strName LIKE '%(+10)%' and kind = 91
delete from ITEM WHERE strName LIKE '%(+6)%' and kind = 92
delete from ITEM WHERE strName LIKE '%(+7)%' and kind = 92
delete from ITEM WHERE strName LIKE '%(+8 )%' and kind = 92
delete from ITEM WHERE strName LIKE '%(+9)%' and kind = 92
delete from ITEM WHERE strName LIKE '%(+10)%' and kind = 92
--Skil Adlarımızı Düzeltelim XD
update magic set krname = 'Minaks Thorn' where magicnum= 212826
update magic set krname = 'Minaks Thorn' where magicnum= 112826
update magic set enname=krname , description = 'Valentine Database Team'
--Monsterler ile Dropları Eşitliyelim
UPDATE K_MONSTER SET sItem = sSid
--K_Monster tablosundaki fazlalıkları alır XD
set rowcount 1
select sSid from K_MONSTER
while @@rowcount>0
delete K_MONSTER
where 1<
(select count(*) from K_MONSTER u2
where K_MONSTER.sSid = u2.sSid)
set rowcount 0
--İtem Tablosundaki FAzlalıları Alır
set rowcount 1
select num from item
while @@rowcount>0
delete item
where 1<
(select count(*) from item u2
where item.num = u2.num)
set rowcount 0
--Magic Tablosundaki Fazlalıkları Alır
set rowcount 1
select Magicnum from Magic
while @@rowcount>0
delete Magic
where 1<
(select count(*) from Magic u2
where Magic.Magicnum = u2.Magicnum)
set rowcount 0
--K_npc deki Fazlalıkları alır
set rowcount 1
select sSid from k_npc
while @@rowcount>0
delete K_npc
where 1<
(select count(*) from K_npc u2
where K_npc.sSid = u2.sSid)
set rowcount 0
GO