Merhaba, Paylaşan arkadaşımız aldığım hata hakkında yardımcı olabilirse çok sevinecem.
Msg 911, Level 16, State 1, Line 1
Database 'SRO_VT_SHARD_INIT' does not exist. Make sure that the name is entered correctly.
Msg 208, Level 16, State 1, Line 21
Invalid object name '_RefPackageItem'.
---- Girmek İstediğim Kodlar - Konuda verilen kodlara göre düzenleyip DB ye atmak istediğimizde yukarıdaki hatayı almaktayım.
USE SRO_VT_SHARD_INIT
GO
DECLARE @ID int
DECLARE @CodeName varchar(129)
DECLARE @DescSTRID varchar(129)
DECLARE @File varchar(129)
DECLARE @Price int
DECLARE @Slot tinyint
DECLARE @TAB varchar(129)
DECLARE @Data int
--- Set Variables
SET @ID = 84037
SET @CodeName = 'ITEM_ETC_HP_SPOTION_01'
SET @DescSTRID = 'SN_ITEM_ETC_HP_SPOTION_01_TT_DESC'
SET @File = 'item\etc\archemy_magicstone_str.ddj'
SET @Price = 30000
SET @Slot = 27
SET @TAB = 'STORE_WC_POTION_TAB1'
SET @Data = 0
SET IDENTITY_INSERT _RefPackageItem ON
INSERT _RefPackageItem
(
[Service],
Country,
ID,
CodeName128,
SaleTag,
ExpandTerm,
NameStrID,
DescStrID,
AssocFileIcon,
Param1,
Param1_Desc128,
Param2,
Param2_Desc128,
Param3,
Param3_Desc128,
Param4,
Param4_Desc128)
VALUES
( 1, 15, @ID,'PACKAGE_ITEM_ETC_HP_SPOTION_01' + @CodeName, 0, 'ITEM_ETC_HP_SPOTION_01', 'SN_ITEM_ETC_HP_SPOTION_01_TT_DESC' + @CodeName, @DescSTRID, @File, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
SET IDENTITY_INSERT _RefPackageItem OFF
INSERT _RefScrapOfPackageItem
(
Service,
Country,
RefPackageItemCodeName,
RefItemCodeName,
OptLevel,
Variance,
Data,
MagParamNum,
MagParam1,
MagParam2,
MagParam3,
MagParam4,
MagParam5,
MagParam6,
MagParam7,
MagParam8,
MagParam9,
MagParam10,
MagParam11,
MagParam12,
Param1,
Param1_Desc128,
Param2,
Param2_Desc128,
Param3,
Param3_Desc128,
Param4,
Param4_Desc128
)
VALUES
(1, 15, 'PACKAGE_ITEM_ETC_HP_SPOTION_01' + @CodeName, @CodeName, 0, 0, @Data, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx' )
INSERT _RefPricePolicyOfItem
(
Service,
Country,
RefPackageItemCodeName,
PaymentDevice,
PreviousCost,
Cost,
Param1,
Param1_Desc128,
Param2,
Param2_Desc128,
Param3,
Param3_Desc128,
Param4,
Param4_Desc128
)
VALUES
(1, 15, 'PACKAGE_ITEM_ETC_HP_SPOTION_01' + @CodeName, 1, 0, @Price, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')
INSERT _RefShopGoods
(
Service,
Country,
RefTabCodeName,
RefPackageItemCodeName,
SlotIndex,
Param1,
Param1_Desc128,
Param2,
Param2_Desc128,
Param3,
Param3_Desc128,
Param4,
Param4_Desc128
)
VALUES
(1, 15, @TAB,'PACKAGE_ITEM_ETC_HP_SPOTION_01' + @CodeName, @Slot, -1, 'xxx', -1, 'xxx', -1, 'xxx', -1, 'xxx')