[MasterioPayBack]

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".