USE [kn_online]
GO
UPDATE [dbo].[ITEM]
SET [Num] = <Num, bigint,>
,[strName] = <strName, varchar(50),>
,[Kind] = <Kind, tinyint,>
,[Slot] = <Slot, tinyint,>
,[Race] = <Race, tinyint,>
,[Class] = <Class, tinyint,>
,[Damage] = <Damage, smallint,>
,[Delay] = <Delay, smallint,>
,[Range] = <Range, smallint,>
,[Weight] = <Weight, smallint,>
,[Duration] = <Duration, smallint,>
,[BuyPrice] = <BuyPrice, int,>
,[SellPrice] = <SellPrice, int,>
,[Ac] = <Ac, smallint,>
,[Countable] = <Countable, tinyint,>
,[Effect1] = <Effect1, int,>
,[Effect2] = <Effect2, int,>
,[ReqLevel] = <ReqLevel, tinyint,>
,[ReqLevelMax] = <ReqLevelMax, tinyint,>
,[ReqRank] = <ReqRank, tinyint,>
,[ReqTitle] = <ReqTitle, tinyint,>
,[ReqStr] = <ReqStr, tinyint,>
,[ReqSta] = <ReqSta, tinyint,>
,[ReqDex] = <ReqDex, tinyint,>
,[ReqIntel] = <ReqIntel, tinyint,>
,[ReqCha] = <ReqCha, tinyint,>
,[SellingGroup] = <SellingGroup, tinyint,>
,[ItemType] = <ItemType, tinyint,>
,[Hitrate] = <Hitrate, smallint,>
,[Evasionrate] = <Evasionrate, smallint,>
,[DaggerAc] = <DaggerAc, smallint,>
,[SwordAc] = <SwordAc, smallint,>
,[MaceAc] = <MaceAc, smallint,>
,[AxeAc] = <AxeAc, smallint,>
,[SpearAc] = <SpearAc, smallint,>
,[BowAc] = <BowAc, smallint,>
,[JamadarAc] = <JamadarAc, smallint,>
,[FireDamage] = <FireDamage, tinyint,>
,[IceDamage] = <IceDamage, tinyint,>
,[LightningDamage] = <LightningDamage, tinyint,>
,[PoisonDamage] = <PoisonDamage, tinyint,>
,[HPDrain] = <HPDrain, tinyint,>
,[MPDamage] = <MPDamage, tinyint,>
,[MPDrain] = <MPDrain, tinyint,>
,[MirrorDamage] = <MirrorDamage, tinyint,>
,[StrB] = <StrB, smallint,>
,[StaB] = <StaB, smallint,>
,[DexB] = <DexB, smallint,>
,[IntelB] = <IntelB, smallint,>
,[ChaB] = <ChaB, smallint,>
,[MaxHpB] = <MaxHpB, smallint,>
,[MaxMpB] = <MaxMpB, smallint,>
,[FireR] = <FireR, smallint,>
,[ColdR] = <ColdR, smallint,>
,[LightningR] = <LightningR, smallint,>
,[MagicR] = <MagicR, smallint,>
,[PoisonR] = <PoisonR, smallint,>
,[CurseR] = <CurseR, smallint,>
WHERE <Search Conditions,,>
GO
[Gizli içerik]
