01.
SET
ANSI_NULLS
OFF
02.
GO
03.
SET
QUOTED_IDENTIFIER
OFF
04.
GO
05.
ALTER
proc [dbo].[MP_MAINQUEST_Update]
06.
(
07.
@CHARACTER_IDX
int
,
08.
@QUEST_IDX
int
,
09.
@SUBQUEST_DO
int
,
10.
@END_PARAM
int
,
11.
@REGIST_TIME
int
12.
)
13.
as
14.
Set
Nocount
On
15.
Set
Xact_Abort
On
16.
17.
update
TB_MAINQUEST
set
18.
SUBQUEST_DO = @SUBQUEST_DO,
19.
END_PARAM = @END_PARAM,
20.
REGIST_TIME = @REGIST_TIME
21.
where
CHARACTER_IDX = @CHARACTER_IDX
and
QUEST_IDX = @QUEST_IDX