×î½üÑо¿ÁËÒ»¶Îʱ¼äµÄÄ«Ïã·þÎñÆ÷£¬ÔÚ2003ϵͳ¡¢SQL2000Öгɹ¦¼ÜÉèÁËÄ«Ïã·þÎñÆ÷²¢ºÍÒ»°ïÈËÒ»Æð²âÊÔÁ˼¸Ìì¡£Î书ÊéÐÞÁ¬²¿ÓùýÑÝÎ䳡¡¢Ö±½Ó12²ãÐÞ¸Ä MP_MUGONG_Insert Õâ¸ö´æ´¢¹ý³Ì¡£ÔÚÊý¾Ý¿âmhgameµÄ´æ´¢¹ý³ÌÀï(×¢Ò⣬ÕâÀïÄãÐèÒªÕ¹¿ªÊý¾Ý¿â£¬È»ºóÕÒµ½ÏÂÃæÓÐÒ»¸ö½Ð´¢´æ¹ý³ÌµÄÈçÏÂͼËùʾ)
--------------------------Ñо¿ÄÚÈÝ--------------------------
´´½¨¹ý³ÌÈçÏ£º
CREATE proc dbo.MP_MUGONG_Insert
(
@CHARACTER_IDX int
, @MUGONG_IDX int
, @MUGONG_POS int
, @MUGONG_WEAR int
, @SUNG int
, @OPTION int
)
as
set nocount on
set xact_abort on
declare @Maxmugong_idx int
if (@CHARACTER_IDX = 0)
begin
-- error
select 0
return
end
insert tb_mugong
(
CHARACTER_IDX,
MUGONG_IDX,
MUGONG_EXPPOINT,
MUGONG_SUNG,
MUGONG_POSITION,
MUGONG_QPOSITION,
MUGONG_WEAR,
MUGONG_OPTION
)
values
(
@CHARACTER_IDX,
@MUGONG_IDX,
1,--1´ú±í²»ÓÃÐÞÁ¶ÑÝÎ䣬0Òª
12,-- @SUNG,ÂòÊéÖ±½ÓÎ书12²ã1-12
@MUGONG_POS,
0,
@MUGONG_WEAR,
@OPTION
)
select @Maxmugong_idx = @@identity
select * from tb_mugong where mugong_dbidx = @Maxmugong_idx
GO
--------------------------Ñо¿ÄÚÈÝ--------------------------
´´½¨¹ý³ÌÈçÏ£º
CREATE proc dbo.MP_MUGONG_Insert
(
@CHARACTER_IDX int
, @MUGONG_IDX int
, @MUGONG_POS int
, @MUGONG_WEAR int
, @SUNG int
, @OPTION int
)
as
set nocount on
set xact_abort on
declare @Maxmugong_idx int
if (@CHARACTER_IDX = 0)
begin
-- error
select 0
return
end
insert tb_mugong
(
CHARACTER_IDX,
MUGONG_IDX,
MUGONG_EXPPOINT,
MUGONG_SUNG,
MUGONG_POSITION,
MUGONG_QPOSITION,
MUGONG_WEAR,
MUGONG_OPTION
)
values
(
@CHARACTER_IDX,
@MUGONG_IDX,
1,--1´ú±í²»ÓÃÐÞÁ¶ÑÝÎ䣬0Òª
12,-- @SUNG,ÂòÊéÖ±½ÓÎ书12²ã1-12
@MUGONG_POS,
0,
@MUGONG_WEAR,
@OPTION
)
select @Maxmugong_idx = @@identity
select * from tb_mugong where mugong_dbidx = @Maxmugong_idx
GO

