help Cash mssql

[riccokell]

Tell me what to add table, Cash point

 

[Stunn]

ALTER TABLE [C9Service].[Server].[TblShopProductDetailInfo] NOCHECK CONSTRAINT ALL




INSERT [C9Service].[Server].[TblShopProductInfo] ([cBranchId], [cProductId], [cProductName], [cMoneyCode], [cPrice], [cDiscountRate], [cRegDate], [cStartDate], [cEndDate], [cProductDesc], [cGiftYN], [cSellTotalCount], [cDuplicateSell], [cUnitName], [cProductType], [cDispOrder], [cDiscountInfo], [cClassName], [cClassKey], [cRefundYN], [cPageNum], [cRecommend], [cLevelMin], [cLevelMax]) VALUES (N'shop03_tap07', N'K_C9_00014563', N'Karas Hunter Set', N'GP_P_COIN', 680,10, N'2.01111e+013', N'2.01111e+013', N'2.01111e+013', N'Karas', 1, 0, 1, N'5个', N'NEW,R', 3, 'NULL', N'猎人', 3, 1, 1, 1, 0, 0)
INSERT [C9Service].[Server].[TblShopProductDetailInfo] ([cChildProductId], [cProductId], [cPrice], [cUnitName], [cValidTerm], [cPossibleLevel], [cUseCount], [cPeriod], [cCoinPrice], [cGameMoneyPrice], [cClassName]) VALUES (N'K_C9_00014563', N'K_C9_00014563', 680, N'Unlimited', 0, 0, 1, 0, 0, 0, N'Hunter')
ALTER TABLE [C9Service].[Server].[TblShopProductDetailInfo] CHECK CONSTRAINT ALL

put it on sql and select the sets by changing the codes . zzzz

 

[riccokell]

thanks

 

[fallenfate]

Thread closed as problem was solved.