抛捞喉抛胶飘.sql

Soul的源代码,类似于劲舞团之类的游戏

create table Item1
(
_Index int primary key IDENTITY(1,1),
_ItemDate int,
_ItemSN	smallint,
_ItemNo	smallint,
_OwnChar varchar(16),
_ItemCount int,
_ItemLevel tinyint,
_ItemCurSp int,
_CurDurability smallint,
_SpFtOption tinyint,
_SpScOption tinyint,
_SpTrOption tinyint,
_SpFrOption tinyint,
_NmFtOption tinyint,
_NmScOption tinyint,
_NmTrOption tinyint
)
select * from Item1 where _OwnChar = 'hoon25500'
select * from char2 where _name = 'hoon29999'
delete from Item1
select * from testData where _name in ('hoon0','hoon1','hoon2','hoon3','hoon4','hoon5')
--drop table item1
/*_OwnChar 俊 努矾胶飘 救等 index汲沥*/
create index Item1IX on Item1(_OwnChar)
/*sp 积己 */
--select
create proc sp_itemSe
    @oname AS varchar(16)
AS
select _ItemDate,_ItemSN,_ItemNo,_ItemCount,_ItemLevel,_ItemCurSp,_CurDurability,_SpFtOption,_SpScOption,
_SpTrOption,_SpFrOption,_NmFtOption,_NmScOption,_NmTrOption 
from Item1 where _OwnChar = @oname
go

create proc sp_itemSe2
    @oname AS varchar(16)
AS
select _Index from Item1 where _OwnChar = @oname
go
--drop proc sp_itemSe
--update
create proc sp_itemUp
@IDt as int, -- _ItemDate
@ITSN as smallint, --_ItemSN
@ITNo as smallint, -- _ItemNo
@OChar as varchar(16), -- _OwnChar
@ITCT as int, -- _ItemCount ,
@ITLV as tinyint, -- _ItemLevel
@ITCS as int, -- _ItemCurSp 
@CD as smallint, -- _CurDurability
@SpFtO as tinyint, -- _SpFtOption
@SpScO as tinyint, -- _SpScOption 
@SpTrO as tinyint, -- _SpTrOption 
@SpFrO as tinyint, -- _SpFrOption 
@NmFtO as tinyint, -- _NmFtOption 
@NmScO as tinyint, -- _NmScOption 
@NMTrO as tinyint -- _NmTrOption 
As
begin tran
update Item1 set _ItemCount = @ITCT ,_ItemLevel = @ITLV,
_ItemCurSp = @ITCS,_CurDurability = @CD,_SpFtOption = @SpFtO,_SpScOption = @SpScO,
_SpTrOption = @SpTrO,_SpFrOption = @SpFrO,_NmFtOption = @NmFtO,_NmScOption = @NmScO,_NmTrOption = @NMTrO
where _OwnChar = @OChar and _ItemSN = @ITSN and _ItemDate = @IDt
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
--drop proc sp_itemUp
--insert
create proc sp_itemIn
--@IDt as int, -- _ItemDate
--@ITSN as smallint, --_ItemSN
--@ITNo as smallint, -- _ItemNo
@OChar as varchar(16) -- _OwnChar
--@ITCT as int, -- _ItemCount ,
--@ITLV as tinyint, -- _ItemLevel
--@ITCS as int, -- _ItemCurSp 
--@CD as int, -- _CurDurability
--@SpFtO as tinyint, -- _SpFtOption
--@SpScO as tinyint, -- _SpScOption 
--@SpTrO as tinyint, -- _SpTrOption 
--@SpFrO as tinyint, -- _SpFrOption 
--@NmFtO as tinyint, -- _NmFtOption 
--@NmScO as tinyint, -- _NmScOption 
--@NMTrO as tinyint -- _NmTrOption 
As
begin tran
insert Item1 values (0,0,0,@OChar,0,0,0,0,0,0,0,0,0,0,0)
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
select * from Item1
/*---------------------------------------------------------------------------------------------------------------------------------*/
create table Item2
(
_Index int not null IDENTITY(1,1), 
_ItemDate int ,
_ItemSN	smallint ,
_ItemNo	smallint ,
_OwnChar varchar(16),
_ItemCount int,
_ItemLevel tinyint,
_ItemCurSp int,
_CurDurability smallint,
_SpFtOption tinyint,
_SpScOption tinyint,
_SpTrOption tinyint,
_SpFrOption tinyint,
_NmFtOption tinyint,
_NmScOption tinyint,
_NmTrOption tinyint
)
/*_Index 俊 努矾胶磐 等 index 汲沥*/
alter table Item2 Add constraint item2clIX primary key clustered(_Index)
select * from Item2
--drop table Item2
/*sp 积己 */
--select
--drop proc sp_item2Se
create proc sp_item2Se
@index1 AS int,@index2 AS int,@index3 AS int,@index4 AS int,@index5 AS int,@index6 AS int,@index7 AS int,@index8 AS int,
@index9 AS int,@index10 AS int,@index11 AS int,@index12 AS int,@index13 AS int,@index14 AS int,@index15 AS int,@index16 AS int,
@index17 AS int,@index18 AS int,@index19 AS int,@index20 AS int,@index21 AS int,@index22 AS int,@index23 AS int,@index24 AS int,
@index25 AS int,@index26 AS int,@index27 AS int,@index28 AS int,@index29 AS int,@index30 AS int,@index31 AS int,@index32 AS int,
@index33 AS int,@index34 AS int,@index35 AS int,@index36 AS int,@index37 AS int,@index38 AS int,@index39 AS int,@index40 AS int,
@index41 AS int,@index42 AS int,@index43 AS int,@index44 AS int,@index45 AS int,@index46 AS int,@index47 AS int,@index48 AS int,
@index49 AS int,@index50 AS int,@index51 AS int,@index52 AS int,@index53 AS int,@index54 AS int,@index55 AS int,@index56 AS int,
@index57 AS int,@index58 AS int,@index59 AS int,@index60 AS int,@index61 AS int,@index62 AS int,@index63 AS int,@index64 AS int,
@index65 AS int,@index66 AS int,@index67 AS int,@index68 AS int,@index69 AS int,@index70 AS int,@index71 AS int,@index72 AS int,
@index73 AS int,@index74 AS int,@index75 AS int,@index76 AS int,@index77 AS int,@index78 AS int,@index79 AS int,@index80 AS int,
@index81 AS int,@index82 AS int,@index83 AS int,@index84 AS int,@index85 AS int,@index86 AS int,@index87 AS int,@index88 AS int,
@index89 AS int,@index90 AS int,@index91 AS int,@index92 AS int,@index93 AS int,@index94 AS int,@index95 AS int,@index96 AS int,
@index97 AS int,@index98 AS int,@index99 AS int,@index100 AS int,@index101 AS int,@index102 AS int,@index103 AS int,@index104 AS int,
@index105 AS int,@index106 AS int,@index107 AS int,@index108 AS int,@index109 AS int,@index110 AS int,@index111 AS int,@index112 AS int,
@index113 AS int,@index114 AS int,@index115 AS int,@index116 AS int,@index117 AS int,@index118 AS int,@index119 AS int,@index120 AS int,
@index121 AS int,@index122 AS int,@index123 AS int,@index124 AS int,@index125 AS int,@index126 AS int,@index127 AS int,@index128 AS int,
@index129 AS int,@index130 AS int,@index131 AS int,@index132 AS int,@index133 AS int,@index134 AS int,@index135 AS int,@index136 AS int,
@index137 AS int,@index138 AS int,@index139 AS int,@index140 AS int,@index141 AS int,@index142 AS int,@index143 AS int,@index144 AS int,
@index145 AS int,@index146 AS int,@index147 AS int,@index148 AS int,@index149 AS int,@index150 AS int
AS
select _ItemDate,_ItemSN,_ItemNo,_ItemCount,_ItemLevel,_ItemCurSp,_CurDurability,_SpFtOption,_SpScOption,
_SpTrOption,_SpFrOption,_NmFtOption,_NmScOption,_NmTrOption 
from Item1 where _Index in (
@index1,@index2,@index3,@index4,@index5,@index6,@index7,@index8,
@index9,@index10,@index11,@index12,@index13,@index14,@index15,@index16,
@index17,@index18,@index19,@index20,@index21,@index22,@index23,@index24,
@index25,@index26,@index27,@index28,@index29,@index30,@index31,@index32,
@index33,@index34,@index35,@index36,@index37,@index38,@index39,@index40,
@index41,@index42,@index43,@index44,@index45,@index46,@index47,@index48,
@index49,@index50,@index51,@index52,@index53,@index54,@index55,@index56,
@index57,@index58,@index59,@index60,@index61,@index62,@index63,@index64,
@index65,@index66,@index67,@index68,@index69,@index70,@index71,@index72,
@index73,@index74,@index75,@index76,@index77,@index78,@index79,@index80,
@index81,@index82,@index83,@index84,@index85,@index86,@index87,@index88,
@index89,@index90,@index91,@index92,@index93,@index94,@index95,@index96,
@index97,@index98,@index99,@index100,@index101,@index102,@index103 ,@index104 ,
@index105 ,@index106 ,@index107 ,@index108 ,@index109 ,@index110 ,@index111 ,@index112 ,
@index113 ,@index114 ,@index115 ,@index116 ,@index117 ,@index118 ,@index119 ,@index120 ,
@index121 ,@index122 ,@index123 ,@index124 ,@index125 ,@index126 ,@index127 ,@index128 ,
@index129 ,@index130 ,@index131 ,@index132 ,@index133 ,@index134 ,@index135 ,@index136 ,
@index137 ,@index138 ,@index139 ,@index140 ,@index141 ,@index142 ,@index143 ,@index144 ,
@index145 ,@index146 ,@index147 ,@index148 ,@index149 ,@index150 )
go

--update
create proc sp_item2Up
@IX as int, -- _Index
@ITCT as int, -- _ItemCount ,
@ITLV as tinyint, -- _ItemLevel
@ITCS as int, -- _ItemCurSp 
@CD as smallint, -- _CurDurability
@SpFtO as tinyint, -- _SpFtOption
@SpScO as tinyint, -- _SpScOption 
@SpTrO as tinyint, -- _SpTrOption
@SpFrO as tinyint, -- _SpFrOption
@NmFtO as tinyint, -- _NmFtOption 
@NmScO as tinyint, -- _NmScOption 
@NMTrO as tinyint -- _NmTrOption 
As
begin tran
update Item2 set _ItemCount = @ITCT ,_ItemLevel = @ITLV,
_ItemCurSp = @ITCS,_CurDurability = @CD,_SpFtOption = @SpFtO,_SpScOption = @SpScO,
_SpTrOption = @SpTrO,_SpFrOption = @SpFrO,_NmFtOption = @NmFtO,_NmScOption = @NmScO,_NmTrOption = @NMTrO
where _Index = @IX
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go
--drop proc sp_item2Up
--insert
create proc sp_item2In
--@IDt as int, -- _ItemDate
--@ITSN as smallint, --_ItemSN
--@ITNo as smallint, -- _ItemNo