49 lines
855 B
Transact-SQL
49 lines
855 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_read_pet_inventory]
|
|
@pet_id [uniqueidentifier]
|
|
|
|
as
|
|
set nocount on
|
|
set transaction isolation level read uncommitted
|
|
|
|
select
|
|
item_uid,
|
|
page_index,
|
|
slot_index,
|
|
code,
|
|
use_cnt,
|
|
remain_time,
|
|
durability,
|
|
enhance_level,
|
|
option_1_code,
|
|
option_1_value,
|
|
option_2_code,
|
|
option_2_value,
|
|
option_3_code,
|
|
option_3_value,
|
|
option_group,
|
|
ReconNum,
|
|
ReconState,
|
|
socket_count,
|
|
socket_1_code,
|
|
socket_1_value,
|
|
socket_2_code,
|
|
socket_2_value,
|
|
socket_3_code,
|
|
socket_3_value,
|
|
--기간제 관련 추가 20100519 jojo
|
|
expire_time,
|
|
lock_pwd,
|
|
activity_value, --활성석 20100928 jojo
|
|
socket_1_color,
|
|
socket_2_color,
|
|
socket_3_color,
|
|
rank,
|
|
acquireroute,
|
|
physical,
|
|
magical,
|
|
durabilitymax,
|
|
weight
|
|
|
|
from dbo.tbl_Pet_Inventory with (nolock) where pet_id = @pet_id and slot_index >= 0 and use_cnt > 0;
|
|
|
|
return @@error
|