Selamlar







İndexten baktım bulamadım, bide istek gördüm, bilenler var bilmiyenler var ona göre yorum yazın













Kod:

DELETE

FROM MAGIC

WHERE (MagicNum = '108685') OR

(MagicNum = '208685')



DELETE

FROM MAGIC_TYPE4

WHERE (iNum = '108685') OR

(iNum = '208685')



INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 108685, 'Å©¸®Æ¼Äà Æ÷ÀÎÆ®', 'Critical Point', '', 0, 0, 0, 1, 10002, 1, 80, 1086, 200, 0, 1, 0, 0, 1, 0, 4, 0, 0, 1, 0 );

INSERT INTO MAGIC ( [MagicNum], [EnName], [KrName], [Description], [BeforeAction], [TargetAction], [SelfEffect], [FlyingEffect], [TargetEffect], [Moral], [SkillLevel], [Skill], [Msp], [HP], [ItemGroup], [UseItem], [CastTime], [ReCastTime], [SuccessRate], [Type1], [Type2], [Range], [Etc], [Event] ) VALUES ( 208685, 'Å©¸®Æ¼Äà Æ÷ÀÎÆ®', 'Critical Point', 'A stabbing technique that disregards opponents defense', 0, 0, 0, 1, 10002, 1, 80, 2086, 200, 0, 1, 0, 0, 1, 0, 4, 0, 0, 1, 0 );



INSERT INTO MAGIC_TYPE4 ( [iNum], [Name], [Description], [BuffType], [Radius], [Duration], [AttackSpeed], [Speed], [AC], [ACPct], [Attack], [MagicAttack], [MaxHP], [MaxHpPct], [MaxMP], [MaxMpPct], [HitRate], [AvoidRate], [Str], [Sta], [Dex], [Intel], [Cha], [FireR], [ColdR], [LightningR], [MagicR], [DiseaseR], [PoisonR], [ExpPct] ) VALUES ( 108685, 'Critical Point', 's', 7, 20, 5, 100, 100, 0, 100, 200, 200, 0, 100, 1, 1, 200, 100, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1 );

INSERT INTO MAGIC_TYPE4 ( [iNum], [Name], [Description], [BuffType], [Radius], [Duration], [AttackSpeed], [Speed], [AC], [ACPct], [Attack], [MagicAttack], [MaxHP], [MaxHpPct], [MaxMP], [MaxMpPct], [HitRate], [AvoidRate], [Str], [Sta], [Dex], [Intel], [Cha], [FireR], [ColdR], [LightningR], [MagicR], [DiseaseR], [PoisonR], [ExpPct] ) VALUES ( 208685, 'Critical Point', 's', 7, 20, 5, 100, 100, 0, 100, 200, 200, 0, 100, 1, 1, 200, 100, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 1 );









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.