مشكلة في Procedure لـSkill Scroll

[iRock]

USE [SRO_VT_LOG]
---- Warrior Skills Scroll
----------------------------------
Declare @CharObjID Int, @MasteryCount Int, @MasteryID Int
Select @CharObjID = RefObjID From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @MasteryCount = (Select Count (*) From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and Level > 0)
IF (@ItemRefID = 41806)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarrior] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarrior] Where Service = 1
END
END
END
END
---- Dagger Skills Scroll
----------------------------------
IF (@ItemRefID = 41807)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsRogue] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsRogue] Where Service = 1
END
END
END
END
---- Wizard Skills Scroll
----------------------------------
IF (@ItemRefID = 41805)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWizard] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWizard] Where Service = 1
End
END
END
End
---- Warlock Skills Scroll
----------------------------------
IF (@ItemRefID = 41810)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarlock] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarlock] Where Service = 1
End
END
End
End

-- Bard Skills Scroll
-------------------------------
IF (@ItemRefID = 41809)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBard] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBard] Where Service = 1
End
END
End
End

-- Claric Skills Scroll
---------------------------------
IF (@ItemRefID = 41808)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsClaric] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsClaric] Where Service = 1
End
End
End
END
---- Bicheon Skills Scroll
----------------------------------
IF (@ItemRefID = 41800)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBicheon] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBicheon] Where Service = 1
End
END
End
End

---- Heuksal Skills Scroll
----------------------------------
IF (@ItemRefID = 41799)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsHeuksal] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsHeuksal] Where Service = 1
End
END
END
End

---- Pacheon Skills Scroll
----------------------------------
IF (@ItemRefID = 41798)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsPacheon] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsPacheon] Where Service = 1
End
END
End
End

---- Cold Skills Scroll
-------------------------------
IF (@ItemRefID = 41803)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsCold] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsCold] Where Service = 1
End
End
End
End

---- Lightning Skills Scroll
-------------------------------------
IF (@ItemRefID = 41802)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsLightning] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsLightning] Where Service = 1
End
End
End
End

---- Fire Skills Scroll
--------------------------------
IF (@ItemRefID = 41801)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsFire] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsFire] Where Service = 1
End
End
End
End

---- Force Skills Scroll
---------------------------------
IF (@ItemRefID = 41804) -- RefObjCommon ID
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsForce] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsForce] Where Service = 1
End
End
End
END

Error
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 16
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 18
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 25
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 34
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 35
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 36
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 43
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 50
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 52
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 53
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 54
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 61
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 68
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 70
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 71
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 72
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 80
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 87
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 89
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 90
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 91
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 99
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 106
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 108
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 109
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 110
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 117
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 124
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 126
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 127
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 128
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 136
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 143
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 145
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 146
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 147
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 155
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 162
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 164
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 165
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 166
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 174
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 181
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 183
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 184
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 185
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 193
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 200
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 202
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 203
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 204
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 212
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 219
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 221
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 222
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 223
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 231
Must declare the scalar variable "@ItemRefID".
Msg 137, Level 15, State 2, Line 238
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 240
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 241
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Line 242
Must declare the scalar variable "@CharID".

انا بستخدم SQL Server 2008 R2 Express

يا ريت لو حد يقولي ايه الغلط اللي في الـ Procedure عشان اصلحه و الـError ده ميطلعش تاني

[محمد منتصر]

ايوه عايز ايه برده ؟

[iRock]

عايز اعرف الError ده اصلحه ازاي

[محمد منتصر]

شوف التابل عندك USE [SRO_VT_LOG] ولا اسمه ايه
+ هو اصلا انت بتعمل ايه ديكلير لايه التابل اللي هتضيف فيه ده موجود ؟ ولا هتعمله كريت اصلا ولا اليرت ليه ؟؟ حدد بلاش كوبي بست افهم انت بتعمل ايه

[iRock]

شوف التابل عندك USE [SRO_VT_LOG] ولا اسمه ايه
+ هو اصلا انت بتعمل ايه ديكلير لايه التابل اللي هتضيف فيه ده موجود ؟ ولا هتعمله كريت اصلا ولا اليرت ليه ؟؟ حدد بلاش كوبي بست افهم انت بتعمل ايه

طبعا التابل كلها موجوده يا باشا و ال ID كلها صح و انا راجعت عليهم اكتر من مره

عملت التابل بالquery ده
USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsBard] Script Date: 6/12/2017 12:17:19 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsBard](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsBicheon] Script Date: 6/12/2017 12:17:34 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsBicheon](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsClaric] Script Date: 6/12/2017 12:17:48 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsClaric](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsCold] Script Date: 6/12/2017 12:17:58 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsCold](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsFire] Script Date: 6/12/2017 12:18:08 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsFire](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsForce] Script Date: 6/12/2017 12:18:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsForce](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsHeuksal] Script Date: 6/12/2017 12:18:39 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsHeuksal](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsLightning] Script Date: 6/12/2017 12:18:49 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsLightning](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsPacheon] Script Date: 6/12/2017 12:18:58 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsPacheon](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsRogue] Script Date: 6/12/2017 12:19:07 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsRogue](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
CONSTRAINT [PK__SkillsRogue] PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsWarlock] Script Date: 6/12/2017 12:19:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWarlock](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsWarrior] Script Date: 6/12/2017 12:19:26 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWarrior](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
CONSTRAINT [PK__SkillsWarrior] PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsWizard] Script Date: 6/12/2017 12:19:34 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWizard](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
CONSTRAINT [PK__SkillsWizard] PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

الف شكر ليك يا ريس علي تفاعلك و مساعدتك

[محمد منتصر]

طبعا التابل كلها موجوده يا باشا و ال ID كلها صح و انا راجعت عليهم اكتر من مره

عملت التابل بالquery ده
USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsBard] Script Date: 6/12/2017 12:17:19 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsBard](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsBicheon] Script Date: 6/12/2017 12:17:34 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsBicheon](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsClaric] Script Date: 6/12/2017 12:17:48 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsClaric](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsCold] Script Date: 6/12/2017 12:17:58 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsCold](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsFire] Script Date: 6/12/2017 12:18:08 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsFire](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsForce] Script Date: 6/12/2017 12:18:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsForce](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsHeuksal] Script Date: 6/12/2017 12:18:39 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsHeuksal](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsLightning] Script Date: 6/12/2017 12:18:49 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsLightning](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsPacheon] Script Date: 6/12/2017 12:18:58 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsPacheon](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsRogue] Script Date: 6/12/2017 12:19:07 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsRogue](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
CONSTRAINT [PK__SkillsRogue] PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsWarlock] Script Date: 6/12/2017 12:19:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWarlock](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsWarrior] Script Date: 6/12/2017 12:19:26 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWarrior](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
CONSTRAINT [PK__SkillsWarrior] PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARD]
GO

/****** Object: Table [dbo].[_SkillsWizard] Script Date: 6/12/2017 12:19:34 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWizard](
[Service] [tinyint] NOT NULL,
[SkillID] [int] NOT NULL,
[SkillName] [varchar](max) NOT NULL,
[MasteryID] [int] NULL,
CONSTRAINT [PK__SkillsWizard] PRIMARY KEY CLUSTERED
(
[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

الف شكر ليك يا ريس علي تفاعلك و مساعدتك

بالظبط ده كده صح اهو محدد انه هيعمل كريت لتابل كل واحد باسم بيلد اهو ومحدد هو عايز ايه لكن الل فوق مش كاتب اي حاجه وكاتب اسم الداتا بيز حتي هتلاقيه مختلف عندك انت فمش هيلاقي مكان يشتغل فيه وهيجيب ايرور