how to use this thing

08/02/2011 20:42 Strange2010#1
hi everyone
I am asking about how can i use this :
USE [Telecaster]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[smp_insert_item]
@IN_SID = 3, --Change this Per Item
@IN_OWNER_ID = IGMIDenio, --Char ID
@IN_ACCOUNT_ID = 0,
@IN_SUMMON_ID = 0,
@IN_AUCTION_ID = 0,
@IN_KEEPING_ID = 0,
@IN_CODE = 910037, --Item Code
@IN_IDX = 100, --Place in Inv (doesnt seem to matter)
@IN_FLAG = 0,
@IN_CNT = 10, --How Many you want
@IN_LEVEL = 1, --Item Level
@IN_ENHANCE = 0, -- Item +
@IN_ENDURANCE = 100,
@IN_GCODE = 1,
@IN_REMAIN_TIME = 0,
@IN_ELEMENTAL_EFFECT_TYPE = 0,
@IN_ELEMENTAL_EFFECT_EXPIRE_TIME = N'1970-01-01 11:00:00.000',
@IN_ELEMENTAL_EFFECT_ATTACK_POINT = 0,
@IN_ELEMENTAL_EFFECT_MAGIC_POINT = 0

SELECT 'Return Value' = @return_value

GO
-----------------
i know it is realated to the dp query or something like that
can anu 1 explain to me how i can use this ?
and ty every1
08/03/2011 01:23 ironhammer500#2
Go on mssql studio manager and click new query copy and paste that then fill in the data needed.

Remove the little help hints then execute
08/03/2011 20:24 Strange2010#3
thanks very much