[SQL] Stored Procedures Optimization

[DeathArt]

I've optimized some of the Stored Procedures for KalOnline.
And I'll post more here further on.

Notice that ItemDefault.csv is required for Insert_Item procedure, and the table layout for it is as following:

USE [hoax]
GO
/****** Object:  Table [dbo].[ItemDefault]    Script Date: 04/28/2007 19:57:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ItemDefault](
	[ItemDefaultId] [int] IDENTITY(1,1) NOT NULL,
	[Job] [tinyint] NULL,
	[Index] [int] NULL,
 CONSTRAINT [PK_ItemDefault] PRIMARY KEY CLUSTERED 
(
	[ItemDefaultId] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

The CSV file contains the data for it.

 

[BigHanded]

hm what it actualy doo?

 

[TrueDarKZONE]

lol dont evan bother trying to play with it bighanded

the thes use thease to do stuff like put the player in to the databace add items ect hes made them better

 

[DeathArt]

Accualy a decompile and some analyses I done recently showed that they aren't in much use. However it would surely be interesting to use them

So just let this post glide into the slipstream, and to be found with search the day someone accualy need it, I'm positive it's usefull for someone.

 

[Marvel]

Thanks, woo im first after 3 years..

 

[ToF]

woho im first after the moron!

 

[.dark.]

aww... i'm second after the necrophiliac moron...

 

[mukso]

Haha just posted something since idk how long

 

[Marvel]

woho im first after the moron!

Circus has gone and left cripple clown..