srodesign
remo
Askar Bilişim
Azel Bilişim
doca sro
Monster Bilişim

 
Konuyu Oyla:
  • Derecelendirme: 0/5 - 0 oy
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Yardımcı Kod Rehberi
(Okunma: 267)
deLLyici
#1
Arkadaşlar bu konu altından SQL kodlarımı sizlerle paylaşacağım vsro dosyalarıyla alakam yoktu pek fazla ama SQL bildiğim için bu işe girmeye karar verdim.


Bu kodu kendinize göre derliyebilirsiniz bu kod aslında hayat kurtarıcı kodlardan birisidir.
Misal 100 tane iteminiz var bunları sileceksiniz dimi. Ya internetten vsro item silme toplu yada elinizle tek tek sileceksiniz.
Bunun Önüne geçmek için bu kodu yazdım temin benim başıma geldi 150 item tek sefer de silmem lazımdı o yüzden çok işinize yarayabilir.
Kod:
/***vsroforum.com**\
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_HA_SET_A_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_SA_SET_A_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_BA_SET_A_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_LA_SET_A_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_FA_SET_A_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_AA_SET_A_RARE'

DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_HA_SET_B_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_SA_SET_B_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_BA_SET_B_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_LA_SET_B_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_FA_SET_B_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_AA_SET_B_RARE'

DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_SET_A_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_SET_B_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_A_RARE'
DELETE  FROM  _RefPricePolicyOfItem WHERE RefPackageItemCodeName like '%11_B_RARE'





DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_HA_SET_A_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_SA_SET_A_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_BA_SET_A_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_LA_SET_A_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_FA_SET_A_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_AA_SET_A_RARE'

DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_HA_SET_B_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_SA_SET_B_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_BA_SET_B_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_LA_SET_B_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_FA_SET_B_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_AA_SET_B_RARE'

DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_SET_A_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_SET_B_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_A_RARE'
DELETE  FROM  _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%11_B_RARE'




DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_HA_SET_A_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_SA_SET_A_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_BA_SET_A_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_LA_SET_A_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_FA_SET_A_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_AA_SET_A_RARE'

DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_HA_SET_B_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_SA_SET_B_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_BA_SET_B_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_LA_SET_B_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_FA_SET_B_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_AA_SET_B_RARE'

DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_SET_A_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_SET_B_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_A_RARE'
DELETE  FROM  _RefShopGoods WHERE RefPackageItemCodeName like '%11_B_RARE'


Son Düzenleme: 17.02.2016, Saat: 04:56, Düzenleyen: deLLyici
Ara
Cevapla
Teşekkür Edenler:
 


Konu ile Alakalı Benzer Konular
Konular Yazar Yorumlar Okunma Son Yorum
  PK2 Edit Rehberi (Yeni başlayanlar için) erolpolat 12 428 03.03.2017, Saat: 15:32
Son Yorum: BURAKSERIT
  SQL Yardımcı Kodlar Scarlet 7 249 26.12.2016, Saat: 10:27
Son Yorum: Scarlet

Hızlı Menü:


Konuyu Okuyanlar: 1 Ziyaretçi
  Tarih: 30.03.2017, Saat: 20:26