Kodlardan fazla anlamıyorum ama kendimce fikir üreterek birseyler yapmaya calısıyorum.







Db mizden kullanılmayan +5 dan sonraki Küpe KOlye Yüzük ve belt leri silelim.







KOdu Kendi DB'mde denedim bir sorun yaşamadım Gönül Rahatlığıyla Kullanabilirsiniz.









Kod:

delete from item where strname like '%Ring (+6)%'

delete from item where strname like '%Ring (+7)%'

delete from item where strname like '%Ring (+8)%'

delete from item where strname like '%Ring (+9)%'

delete from item where strname like '%Ring (+10)%'



delete from item where strname like '%Pendant (+6)%'

delete from item where strname like '%Pendant (+7)%'

delete from item where strname like '%Pendant (+8)%'

delete from item where strname like '%Pendant (+9)%'

delete from item where strname like '%Pendant (+10)%'





delete from item where strname like '%Belt (+6)%'

delete from item where strname like '%Belt (+7)%'

delete from item where strname like '%Belt (+8)%'

delete from item where strname like '%Belt (+9)%'

delete from item where strname like '%Belt (+10)%'





delete from item where strname like '%Earring (+6)%'

delete from item where strname like '%Earring (+7)%'

delete from item where strname like '%Earring (+8)%'

delete from item where strname like '%Earring (+9)%'

delete from item where strname like '%Earring (+10)%'





Kullanımı ...







1 Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.



2 SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.



3 Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.