Selamlar Buyrun









Kod:

delete from item where strname like '%+6%' and slot = '10'

delete from item where strname like '%+7%' and slot = '10'

delete from item where strname like '%+8%' and slot = '10'

delete from item where strname like '%+9%' and slot = '10'

delete from item where strname like '%+10%' and slot = '10'



delete from item where strname like '%+6%' and slot = '11'

delete from item where strname like '%+7%' and slot = '11'

delete from item where strname like '%+8%' and slot = '11'

delete from item where strname like '%+9%' and slot = '11'

delete from item where strname like '%+10%' and slot = '11'



delete from item where strname like '%+6%' and slot = '12'

delete from item where strname like '%+7%' and slot = '12'

delete from item where strname like '%+8%' and slot = '12'

delete from item where strname like '%+9%' and slot = '12'

delete from item where strname like '%+10%' and slot = '12'



delete from item where strname like '%+6%' and slot = '14'

delete from item where strname like '%+7%' and slot = '14'

delete from item where strname like '%+8%' and slot = '14'

delete from item where strname like '%+9%' and slot = '14'

delete from item where strname like '%+10%' and slot = '14'





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.