[Mahmoud Rashwan]

المشاركة الأصلية كتبت بواسطة MikrotikBody

حضرتك الكيوري اللي فوق زاي اللي تحت ايه الأختلاف مش فاهم



بص يا أستاذي العزيز عشان متلفش حوالين نفسك
عشان تمسح Npc أستخدم الكيوري ده

use SRO_VT_SHARD 
Delete from Tab_RefHive where dwHiveID IN ( select dwHiveID from Tab_RefNest where dwTacticsID IN ( select dwTacticsID from Tab_RefTactics where dwObjID IN ( select ID from _RefObjCommon where CodeName128 like 'Codename NPC%'))) 
Delete from Tab_RefNest where dwTacticsID IN ( select dwTacticsID from Tab_RefTactics where dwObjID IN ( select ID from _RefObjCommon where CodeName128 like 'Codename NPC%')) 
Delete from Tab_RefTactics where dwTacticsID IN ( select dwTacticsID from Tab_RefTactics where dwObjID IN ( select ID from _RefObjCommon where CodeName128 like 'Codename NPC%'))   
Delete from _RefObjChar where ID IN ( select Link from _RefObjCommon where CodeName128 like 'Codename NPC%' ) 
Delete from _RefObjCommon where CodeName128 Like '%Codename NPC%' 
Delete from _RefShop where CodeName128 like '%Codename NPC%' 
Delete from _RefShopGroup where CodeName128 like '%Codename NPC%' 
Delete from _RefShopItemGroup where CodeName128 like '%Codename NPC%' 
Delete from _RefShopTab where CodeName128 like '%Codename NPC%' 
Delete from _RefShopTabGroup where CodeName128 like '%Codename NPC%' 
Delete from _RefMappingShopGroup where RefShopCodeName like '%Codename NPC%' 
Delete from _RefMappingShopWithTab where RefShopCodeName like '%Codename NPC%'

تمـ التعديل