MasterioPayBack
26-02-2017, 10:14 PM
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_ModelSwitch] Script Date: 25.02.2017 16:41:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_ModelSwitch13D]
@ChariD Int
As
-- Declare expression.
Declare @CreaterName Varchar(60) = 'Leo' , -- Creater Name
@weaponslot INT = 13 ,
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'
@Old_CH_TBLADE_ID int = 25672 , @New_CH_TBLADE_ID int = 42876, --ch tblade
--------------------------------------------------------------------------------------------
-- Start Upgrade system :
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @ChariD and Slot = @weaponslot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID
GO
بعمل الكويري دي عشان التابل بس بيجي مشاكل و انا عملت declare
ممكن حل ؟
ده الايرور :
Msg 156, Level 15, State 1, Procedure _ModelSwitch13D, Line 24
Incorrect syntax near the keyword 'Update'.
Msg 137, Level 15, State 2, Procedure _ModelSwitch13D, Line 24
Must declare the scalar variable "@New_CH_TBLADE_ID".
Msg 137, Level 15, State 2, Procedure _ModelSwitch13D, Line 24
Must declare the scalar variable "@weaponslot".
GO
/****** Object: StoredProcedure [dbo].[_ModelSwitch] Script Date: 25.02.2017 16:41:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_ModelSwitch13D]
@ChariD Int
As
-- Declare expression.
Declare @CreaterName Varchar(60) = 'Leo' , -- Creater Name
@weaponslot INT = 13 ,
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'
@Old_CH_TBLADE_ID int = 25672 , @New_CH_TBLADE_ID int = 42876, --ch tblade
--------------------------------------------------------------------------------------------
-- Start Upgrade system :
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @ChariD and Slot = @weaponslot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID
GO
بعمل الكويري دي عشان التابل بس بيجي مشاكل و انا عملت declare
ممكن حل ؟
ده الايرور :
Msg 156, Level 15, State 1, Procedure _ModelSwitch13D, Line 24
Incorrect syntax near the keyword 'Update'.
Msg 137, Level 15, State 2, Procedure _ModelSwitch13D, Line 24
Must declare the scalar variable "@New_CH_TBLADE_ID".
Msg 137, Level 15, State 2, Procedure _ModelSwitch13D, Line 24
Must declare the scalar variable "@weaponslot".