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.
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.