store2update.sql

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

As
SET NOCOUNT on
begin tran


update dbo.StoreItem2 set  
_ItemDate0 = @iIDate0, _ItemSN0 = @siISN0, _ItemNo0 = @siINo0, _ItemCount0 = @iICount0, 
_ItemLevel0 = @bILv0, _iSpOption0 = @iSpOption0, _SttOption0 = @shSttOption0,
_ItemDate1 = @iIDate1, _ItemSN1 = @siISN1, _ItemNo1 = @siINo1, _ItemCount1 = @iICount1,
_ItemLevel1 = @bILv1, _iSpOption1 = @iSpOption1, _SttOption1 = @shSttOption1,
_ItemDate2 = @iIDate2, _ItemSN2 = @siISN2, _ItemNo2 = @siINo2, _ItemCount2 = @iICount2,
_ItemLevel2 = @bILv2,  _iSpOption2 = @iSpOption2, _SttOption2 = @shSttOption2, 
_ItemDate3 = @iIDate3, _ItemSN3 = @siISN3, _ItemNo3 = @siINo3, _ItemCount3 = @iICount3,
_ItemLevel3 = @bILv3,  _iSpOption3 = @iSpOption3, _SttOption3 = @shSttOption3,
_ItemDate4 = @iIDate4, _ItemSN4 = @siISN4, _ItemNo4 = @siINo4, _ItemCount4 = @iICount4,
_ItemLevel4 = @bILv4,  _iSpOption4 = @iSpOption4, _SttOption4 = @shSttOption4,
_ItemDate5 = @iIDate5, _ItemSN5 = @siISN5, _ItemNo5 = @siINo5, _ItemCount5 = @iICount5,
_ItemLevel5 = @bILv5,  _iSpOption5 = @iSpOption5, _SttOption5 = @shSttOption5,
_ItemDate6 = @iIDate6, _ItemSN6 = @siISN6, _ItemNo6 = @siINo6, _ItemCount6 = @iICount6,
_ItemLevel6 = @bILv6, _iSpOption6 = @iSpOption6, _SttOption6 = @shSttOption6,
_ItemDate7 = @iIDate7, _ItemSN7 = @siISN7, _ItemNo7 = @siINo7, _ItemCount7 = @iICount7,
_ItemLevel7 = @bILv7, _iSpOption7 = @iSpOption7, _SttOption7 = @shSttOption7,
_ItemDate8 = @iIDate8, _ItemSN8 = @siISN8, _ItemNo8 = @siINo8, _ItemCount8 = @iICount8,
_ItemLevel8 = @bILv8, _iSpOption8 = @iSpOption8, _SttOption8 = @shSttOption8,
_ItemDate9 = @iIDate9, _ItemSN9 = @siISN9, _ItemNo9 = @siINo9, _ItemCount9 = @iICount9,
_ItemLevel9 = @bILv9, _iSpOption9 = @iSpOption9, _SttOption9 = @shSttOption9,

_ItemDate10 = @iIDate10, _ItemSN10 = @siISN10, _ItemNo10 = @siINo10, _ItemCount10 = @iICount10, 
_ItemLevel10 = @bILv10, _iSpOption10 = @iSpOption10, _SttOption10 = @shSttOption10,
_ItemDate11 = @iIDate11, _ItemSN11 = @siISN11, _ItemNo11 = @siINo11, _ItemCount11 = @iICount11,
_ItemLevel11 = @bILv11, _iSpOption11 = @iSpOption11, _SttOption11 = @shSttOption11,
_ItemDate12 = @iIDate12, _ItemSN12 = @siISN12, _ItemNo12 = @siINo12, _ItemCount12 = @iICount12,
_ItemLevel12 = @bILv12,  _iSpOption12 = @iSpOption12, _SttOption12 = @shSttOption12, 
_ItemDate13 = @iIDate13, _ItemSN13 = @siISN13, _ItemNo13 = @siINo13, _ItemCount13 = @iICount13,
_ItemLevel13 = @bILv13,  _iSpOption13 = @iSpOption13, _SttOption13 = @shSttOption13,
_ItemDate14 = @iIDate14, _ItemSN14 = @siISN14, _ItemNo14 = @siINo14, _ItemCount14 = @iICount14,
_ItemLevel14 = @bILv14,  _iSpOption14 = @iSpOption14, _SttOption14 = @shSttOption14,
_ItemDate15 = @iIDate15, _ItemSN15 = @siISN15, _ItemNo15 = @siINo15, _ItemCount15 = @iICount15,
_ItemLevel15 = @bILv15,  _iSpOption15 = @iSpOption15, _SttOption15 = @shSttOption15,
_ItemDate16 = @iIDate16, _ItemSN16 = @siISN16, _ItemNo16 = @siINo16, _ItemCount16 = @iICount16,
_ItemLevel16 = @bILv16, _iSpOption16 = @iSpOption16, _SttOption16 = @shSttOption16,
_ItemDate17 = @iIDate17, _ItemSN17 = @siISN17, _ItemNo17 = @siINo17, _ItemCount17 = @iICount17,
_ItemLevel17 = @bILv17, _iSpOption17 = @iSpOption17, _SttOption17 = @shSttOption17,
_ItemDate18 = @iIDate18, _ItemSN18 = @siISN18, _ItemNo18 = @siINo18, _ItemCount18 = @iICount18,
_ItemLevel18 = @bILv18, _iSpOption18 = @iSpOption18, _SttOption18 = @shSttOption18,
_ItemDate19 = @iIDate19, _ItemSN19 = @siISN19, _ItemNo19 = @siINo19, _ItemCount19 = @iICount19,
_ItemLevel19 = @bILv19, _iSpOption19 = @iSpOption19, _SttOption19 = @shSttOption19,

_ItemDate20 = @iIDate20, _ItemSN20 = @siISN20, _ItemNo20 = @siINo20, _ItemCount20 = @iICount20, 
_ItemLevel20 = @bILv20, _iSpOption20 = @iSpOption20, _SttOption20 = @shSttOption20,
_ItemDate21 = @iIDate21, _ItemSN21 = @siISN21, _ItemNo21 = @siINo21, _ItemCount21 = @iICount21,
_ItemLevel21 = @bILv21, _iSpOption21 = @iSpOption21, _SttOption21 = @shSttOption21,
_ItemDate22 = @iIDate22, _ItemSN22 = @siISN22, _ItemNo22 = @siINo22, _ItemCount22 = @iICount22,
_ItemLevel22 = @bILv22,  _iSpOption22 = @iSpOption22, _SttOption22 = @shSttOption22, 
_ItemDate23 = @iIDate23, _ItemSN23 = @siISN23, _ItemNo23 = @siINo23, _ItemCount23 = @iICount23,
_ItemLevel23 = @bILv23,  _iSpOption23 = @iSpOption23, _SttOption23 = @shSttOption23,
_ItemDate24 = @iIDate24, _ItemSN24 = @siISN24, _ItemNo24 = @siINo24, _ItemCount24 = @iICount24,
_ItemLevel24 = @bILv24,  _iSpOption24 = @iSpOption24, _SttOption24 = @shSttOption24,
_ItemDate25 = @iIDate25, _ItemSN25 = @siISN25, _ItemNo25 = @siINo25, _ItemCount25 = @iICount25,
_ItemLevel25 = @bILv25,  _iSpOption25 = @iSpOption25, _SttOption25 = @shSttOption25,
_ItemDate26 = @iIDate26, _ItemSN26 = @siISN26, _ItemNo26 = @siINo26, _ItemCount26 = @iICount26,
_ItemLevel26 = @bILv26, _iSpOption26 = @iSpOption26, _SttOption26 = @shSttOption26,
_ItemDate27 = @iIDate27, _ItemSN27 = @siISN27, _ItemNo27 = @siINo27, _ItemCount27 = @iICount27,
_ItemLevel27 = @bILv27, _iSpOption27 = @iSpOption27, _SttOption27 = @shSttOption27,
_ItemDate28 = @iIDate28, _ItemSN28 = @siISN28, _ItemNo28 = @siINo28, _ItemCount28 = @iICount28,
_ItemLevel28 = @bILv28, _iSpOption28 = @iSpOption28, _SttOption28 = @shSttOption28,
_ItemDate29 = @iIDate29, _ItemSN29 = @siISN29, _ItemNo29 = @siINo29, _ItemCount29 = @iICount29,
_ItemLevel29 = @bILv29, _iSpOption29 = @iSpOption29, _SttOption29 = @shSttOption29,

_ItemDate30 = @iIDate30, _ItemSN30 = @siISN30, _ItemNo30 = @siINo30, _ItemCount30 = @iICount30, 
_ItemLevel30 = @bILv30, _iSpOption30 = @iSpOption30, _SttOption30 = @shSttOption30,
_ItemDate31 = @iIDate31, _ItemSN31 = @siISN31, _ItemNo31 = @siINo31, _ItemCount31 = @iICount31,
_ItemLevel31 = @bILv31, _iSpOption31 = @iSpOption31, _SttOption31 = @shSttOption31,
_ItemDate32 = @iIDate32, _ItemSN32 = @siISN32, _ItemNo32 = @siINo32, _ItemCount32 = @iICount32,
_ItemLevel32 = @bILv32,  _iSpOption32 = @iSpOption32, _SttOption32 = @shSttOption32, 
_ItemDate33 = @iIDate33, _ItemSN33 = @siISN33, _ItemNo33 = @siINo33, _ItemCount33 = @iICount33,
_ItemLevel33 = @bILv33,  _iSpOption33 = @iSpOption33, _SttOption33 = @shSttOption33,
_ItemDate34 = @iIDate34, _ItemSN34 = @siISN34, _ItemNo34 = @siINo34, _ItemCount34 = @iICount34,
_ItemLevel34 = @bILv34,  _iSpOption34 = @iSpOption34, _SttOption34 = @shSttOption34,
_ItemDate35 = @iIDate35, _ItemSN35 = @siISN35, _ItemNo35 = @siINo35, _ItemCount35 = @iICount35,
_ItemLevel35 = @bILv35,  _iSpOption35 = @iSpOption35, _SttOption35 = @shSttOption35,
_ItemDate36 = @iIDate36, _ItemSN36 = @siISN36, _ItemNo36 = @siINo36, _ItemCount36 = @iICount36,
_ItemLevel36 = @bILv36, _iSpOption36 = @iSpOption36, _SttOption36 = @shSttOption36,
_ItemDate37 = @iIDate37, _ItemSN37 = @siISN37, _ItemNo37 = @siINo37, _ItemCount37 = @iICount37,
_ItemLevel37 = @bILv37, _iSpOption37 = @iSpOption37, _SttOption37 = @shSttOption37,
_ItemDate38 = @iIDate38, _ItemSN38 = @siISN38, _ItemNo38 = @siINo38, _ItemCount38 = @iICount38,
_ItemLevel38 = @bILv38, _iSpOption38 = @iSpOption38, _SttOption38 = @shSttOption38,
_ItemDate39 = @iIDate39, _ItemSN39 = @siISN39, _ItemNo39 = @siINo39, _ItemCount39 = @iICount39,
_ItemLevel39 = @bILv39, _iSpOption39 = @iSpOption39, _SttOption39 = @shSttOption39,

_ItemDate40 = @iIDate40, _ItemSN40 = @siISN40, _ItemNo40 = @siINo40, _ItemCount40 = @iICount40, 
_ItemLevel40 = @bILv40, _iSpOption40 = @iSpOption40, _SttOption40 = @shSttOption40,
_ItemDate41 = @iIDate41, _ItemSN41 = @siISN41, _ItemNo41 = @siINo41, _ItemCount41 = @iICount41,
_ItemLevel41 = @bILv41, _iSpOption41 = @iSpOption41, _SttOption41 = @shSttOption41,
_ItemDate42 = @iIDate42, _ItemSN42 = @siISN42, _ItemNo42 = @siINo42, _ItemCount42 = @iICount42,
_ItemLevel42 = @bILv42,  _iSpOption42 = @iSpOption42, _SttOption42 = @shSttOption42, 
_ItemDate43 = @iIDate43, _ItemSN43 = @siISN43, _ItemNo43 = @siINo43, _ItemCount43 = @iICount43,
_ItemLevel43 = @bILv43,  _iSpOption43 = @iSpOption43, _SttOption43 = @shSttOption43,
_ItemDate44 = @iIDate44, _ItemSN44 = @siISN44, _ItemNo44 = @siINo44, _ItemCount44 = @iICount44,
_ItemLevel44 = @bILv44,  _iSpOption44 = @iSpOption44, _SttOption44 = @shSttOption44,
_ItemDate45 = @iIDate45, _ItemSN45 = @siISN45, _ItemNo45 = @siINo45, _ItemCount45 = @iICount45,
_ItemLevel45 = @bILv45,  _iSpOption45 = @iSpOption45, _SttOption45 = @shSttOption45,
_ItemDate46 = @iIDate46, _ItemSN46 = @siISN46, _ItemNo46 = @siINo46, _ItemCount46 = @iICount46,
_ItemLevel46 = @bILv46, _iSpOption46 = @iSpOption46, _SttOption46 = @shSttOption46,
_ItemDate47 = @iIDate47, _ItemSN47 = @siISN47, _ItemNo47 = @siINo47, _ItemCount47 = @iICount47,
_ItemLevel47 = @bILv47, _iSpOption47 = @iSpOption47, _SttOption47 = @shSttOption47,
_ItemDate48 = @iIDate48, _ItemSN48 = @siISN48, _ItemNo48 = @siINo48, _ItemCount48 = @iICount48,
_ItemLevel48 = @bILv48, _iSpOption48 = @iSpOption48, _SttOption48 = @shSttOption48,
_ItemDate49 = @iIDate49, _ItemSN49 = @siISN49, _ItemNo49 = @siINo49, _ItemCount49 = @iICount49,
_ItemLevel49 = @bILv49, _iSpOption49 = @iSpOption49, _SttOption49 = @shSttOption49,

_ItemDate50 = @iIDate50, _ItemSN50 = @siISN50, _ItemNo50 = @siINo50, _ItemCount50 = @iICount50, 
_ItemLevel50 = @bILv50, _iSpOption50 = @iSpOption50, _SttOption50 = @shSttOption50,
_ItemDate51 = @iIDate51, _ItemSN51 = @siISN51, _ItemNo51 = @siINo51, _ItemCount51 = @iICount51,
_ItemLevel51 = @bILv51, _iSpOption51 = @iSpOption51, _SttOption51 = @shSttOption51,
_ItemDate52 = @iIDate52, _ItemSN52 = @siISN52, _ItemNo52 = @siINo52, _ItemCount52 = @iICount52,
_ItemLevel52 = @bILv52,  _iSpOption52 = @iSpOption52, _SttOption52 = @shSttOption52, 
_ItemDate53 = @iIDate53, _ItemSN53 = @siISN53, _ItemNo53 = @siINo53, _ItemCount53 = @iICount53,
_ItemLevel53 = @bILv53,  _iSpOption53 = @iSpOption53, _SttOption53 = @shSttOption53,
_ItemDate54 = @iIDate54, _ItemSN54 = @siISN54, _ItemNo54 = @siINo54, _ItemCount54 = @iICount54,
_ItemLevel54 = @bILv54,  _iSpOption54 = @iSpOption54, _SttOption54 = @shSttOption54,
_ItemDate55 = @iIDate55, _ItemSN55 = @siISN55, _ItemNo55 = @siINo55, _ItemCount55 = @iICount55,
_ItemLevel55 = @bILv55,  _iSpOption55 = @iSpOption55, _SttOption55 = @shSttOption55,
_ItemDate56 = @iIDate56, _ItemSN56 = @siISN56, _ItemNo56 = @siINo56, _ItemCount56 = @iICount56,
_ItemLevel56 = @bILv56, _iSpOption56 = @iSpOption56, _SttOption56 = @shSttOption56,
_ItemDate57 = @iIDate57, _ItemSN57 = @siISN57, _ItemNo57 = @siINo57, _ItemCount57 = @iICount57,
_ItemLevel57 = @bILv57, _iSpOption57 = @iSpOption57, _SttOption57 = @shSttOption57,
_ItemDate58 = @iIDate58, _ItemSN58 = @siISN58, _ItemNo58 = @siINo58, _ItemCount58 = @iICount58,
_ItemLevel58 = @bILv58, _iSpOption58 = @iSpOption58, _SttOption58 = @shSttOption58,
_ItemDate59 = @iIDate59, _ItemSN59 = @siISN59, _ItemNo59 = @siINo59, _ItemCount59 = @iICount59,
_ItemLevel59 = @bILv59, _iSpOption59 = @iSpOption59, _SttOption59 = @shSttOption59,

_ItemDate60 = @iIDate60, _ItemSN60 = @siISN60, _ItemNo60 = @siINo60, _ItemCount60 = @iICount60, 
_ItemLevel60 = @bILv60, _iSpOption60 = @iSpOption60, _SttOption60 = @shSttOption60,
_ItemDate61 = @iIDate61, _ItemSN61 = @siISN61, _ItemNo61 = @siINo61, _ItemCount61 = @iICount61,
_ItemLevel61 = @bILv61, _iSpOption61 = @iSpOption61, _SttOption61 = @shSttOption61,
_ItemDate62 = @iIDate62, _ItemSN62 = @siISN62, _ItemNo62 = @siINo62, _ItemCount62 = @iICount62,
_ItemLevel62 = @bILv62,  _iSpOption62 = @iSpOption62, _SttOption62 = @shSttOption62, 
_ItemDate63 = @iIDate63, _ItemSN63 = @siISN63, _ItemNo63 = @siINo63, _ItemCount63 = @iICount63,
_ItemLevel63 = @bILv63,  _iSpOption63 = @iSpOption63, _SttOption63 = @shSttOption63,
_ItemDate64 = @iIDate64, _ItemSN64 = @siISN64, _ItemNo64 = @siINo64, _ItemCount64 = @iICount64,
_ItemLevel64 = @bILv64,  _iSpOption64 = @iSpOption64, _SttOption64 = @shSttOption64,
_ItemDate65 = @iIDate65, _ItemSN65 = @siISN65, _ItemNo65 = @siINo65, _ItemCount65 = @iICount65,
_ItemLevel65 = @bILv65,  _iSpOption65 = @iSpOption65, _SttOption65 = @shSttOption65,
_ItemDate66 = @iIDate66, _ItemSN66 = @siISN66, _ItemNo66 = @siINo66, _ItemCount66 = @iICount66,
_ItemLevel66 = @bILv66, _iSpOption66 = @iSpOption66, _SttOption66 = @shSttOption66,
_ItemDate67 = @iIDate67, _ItemSN67 = @siISN67, _ItemNo67 = @siINo67, _ItemCount67 = @iICount67,
_ItemLevel67 = @bILv67, _iSpOption67 = @iSpOption67, _SttOption67 = @shSttOption67,
_ItemDate68 = @iIDate68, _ItemSN68 = @siISN68, _ItemNo68 = @siINo68, _ItemCount68 = @iICount68,
_ItemLevel68 = @bILv68, _iSpOption68 = @iSpOption68, _SttOption68 = @shSttOption68,
_ItemDate69 = @iIDate69, _ItemSN69 = @siISN69, _ItemNo69 = @siINo69, _ItemCount69 = @iICount69,
_ItemLevel69 = @bILv69, _iSpOption69 = @iSpOption69, _SttOption69 = @shSttOption69,

_ItemDate70 = @iIDate70, _ItemSN70 = @siISN70, _ItemNo70 = @siINo70, _ItemCount70 = @iICount70, 
_ItemLevel70 = @bILv70, _iSpOption70 = @iSpOption70, _SttOption70 = @shSttOption70,
_ItemDate71 = @iIDate71, _ItemSN71 = @siISN71, _ItemNo71 = @siINo71, _ItemCount71 = @iICount71,
_ItemLevel71 = @bILv71, _iSpOption71 = @iSpOption71, _SttOption71 = @shSttOption71,
_ItemDate72 = @iIDate72, _ItemSN72 = @siISN72, _ItemNo72 = @siINo72, _ItemCount72 = @iICount72,
_ItemLevel72 = @bILv72,  _iSpOption72 = @iSpOption72, _SttOption72 = @shSttOption72, 
_ItemDate73 = @iIDate73, _ItemSN73 = @siISN73, _ItemNo73 = @siINo73, _ItemCount73 = @iICount73,
_ItemLevel73 = @bILv73,  _iSpOption73 = @iSpOption73, _SttOption73 = @shSttOption73,
_ItemDate74 = @iIDate74, _ItemSN74 = @siISN74, _ItemNo74 = @siINo74, _ItemCount74 = @iICount74,
_ItemLevel74 = @bILv74,  _iSpOption74 = @iSpOption74, _SttOption74 = @shSttOption74,
_ItemDate75 = @iIDate75, _ItemSN75 = @siISN75, _ItemNo75 = @siINo75, _ItemCount75 = @iICount75,
_ItemLevel75 = @bILv75,  _iSpOption75 = @iSpOption75, _SttOption75 = @shSttOption75,
_ItemDate76 = @iIDate76, _ItemSN76 = @siISN76, _ItemNo76 = @siINo76, _ItemCount76 = @iICount76,
_ItemLevel76 = @bILv76, _iSpOption76 = @iSpOption76, _SttOption76 = @shSttOption76,
_ItemDate77 = @iIDate77, _ItemSN77 = @siISN77, _ItemNo77 = @siINo77, _ItemCount77 = @iICount77,
_ItemLevel77 = @bILv77, _iSpOption77 = @iSpOption77, _SttOption77 = @shSttOption77

where _iAccountID = @iIndex
-- 费归俊 狐牶促 酒捞袍 墨款飘 tinyint
if @@Error <> 0
	begin
		rollback tran
	end
else
	begin
		commit tran
	end
go