Guide Organize your ITEM table.

budsmoker997 · 10-30-2008, 04:58 PM

First
To prevent from loosing data.

Open Query Analyzer and execute the following.

Code:

USE [KN_Online]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITEM1](
[Num] [int] NULL,
[strName] [char](50) NULL,
[Kind] [tinyint] NULL,
[Slot] [tinyint] NULL,
[Race] [tinyint] NULL,
[Class] [tinyint] NULL,
[Damage] [smallint] NULL,
[Delay] [smallint] NULL,
[Range] [smallint] NULL,
[Weight] [smallint] NULL,
[Duration] [smallint] NULL,
[BuyPrice] [int] NULL,
[SellPrice] [int] NULL,
[Ac] [smallint] NULL,
[Countable] [tinyint] NULL,
[Effect1] [int] NULL,
[Effect2] [int] NULL,
[ReqLevel] [tinyint] NULL,
[ReqLevelMax] [tinyint] NULL,
[ReqRank] [tinyint] NULL,
[ReqTitle] [tinyint] NULL,
[ReqStr] [tinyint] NULL,
[ReqSta] [tinyint] NULL,
[ReqDex] [tinyint] NULL,
[ReqIntel] [tinyint] NULL,
[ReqCha] [tinyint] NULL,
[SellingGroup] [tinyint] NULL,
[ItemType] [tinyint] NULL,
[Hitrate] [smallint] NULL,
[Evasionrate] [smallint] NULL,
[DaggerAc] [smallint] NULL,
[SwordAc] [smallint] NULL,
[MaceAc] [smallint] NULL,
[AxeAc] [smallint] NULL,
[SpearAc] [smallint] NULL,
[BowAc] [smallint] NULL,
[FireDamage] [tinyint] NULL,
[IceDamage] [tinyint] NULL,
[LightningDamage] [tinyint] NULL,
[PoisonDamage] [tinyint] NULL,
[HPDrain] [tinyint] NULL,
[MPDamage] [tinyint] NULL,
[MPDrain] [tinyint] NULL,
[MirrorDamage] [tinyint] NULL,
[Droprate] [tinyint] NULL,
[StrB] [smallint] NULL,
[StaB] [smallint] NULL,
[DexB] [smallint] NULL,
[IntelB] [smallint] NULL,
[ChaB] [smallint] NULL,
[MaxHpB] [smallint] NULL,
[MaxMpB] [smallint] NULL,
[FireR] [smallint] NULL,
[ColdR] [smallint] NULL,
[LightningR] [smallint] NULL,
[MagicR] [smallint] NULL,
[PoisonR] [smallint] NULL,
[CurseR] [smallint] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

Secondly
Execute the code below in a new Query.

Code:

SELECT KN_online.dbo.ITEM
ORDER BY NUM

The ITEM Table will be displayed below ordered by the NUM Column.

Third
Click any part of the table shown below and do the following.

Code:

Right Click > Select All

Right Click > Copy

Fourth
Go to KN_Online > Tables > Item1.
Open Item1 click the empty row then do the following.

Code:

Right Click > Paste

NOTE: IT WILL TAKE SEVERAL MINUTES TO COMPLETE

Fifth
Delete ITEM
Rename ITEM1 to ITEM

YOUR DONE

I know this inst really important but I myself hate something unorganized. I was looking for this but i couldn't find out how to do it so upon learning how i made this guide. Hope it helps some of you.

P.S THIS CAN ALSO BE USED TO TRANSFER DATA BETWEEN VERSIONS OF SQL AND BETWEEN 2 DATABASES

Credits-GoDofWaR

spamman · 10-31-2008, 12:31 AM

why don't you just make an index? lol would be much quicker w/o copy and pasting over 60k rows...

budsmoker997 · 10-31-2008, 04:10 AM

Quote: Originally Posted by spamman

why don't you just make an index? lol would be much quicker w/o copy and pasting over 60k rows...

TBH! I am a noob at SQL ^^

RaGEZONE is proudly sponsored by