حفظ بياناتي ؟

1/01/2023

22/05/2024_hema

22/05/2024_hema

END_shaher_01/12/2024

Ahmed_k_nayel_01_12_2024

END_02/12/2024

END 30/12/2024

END 06/12/2024

END 28/12/2024

END 30/12/2024_waiting

END 30/02/2025_Belal

END 06/01/2025

END 12/01/2025

END _14/01/2025_Karuoke

END _14/01/2025_Karuoke

25/01/2022

QueenSro_01_10_2024

Ahmed_k_nayel_01_12_2024

ibrahim_END 07/1212024

END 30/12/2024

END 12/01/2025

END _14/01/2025_Karuoke

 الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group 



قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ]

إضافة رد
 
أدوات الموضوع انواع عرض الموضوع
قديم 01-12-2019, 05:14 PM   #1

iRock
عضو جديد



الصورة الرمزية iRock


• الانـتـسـاب » Feb 2010
• رقـم العـضـويـة » 69996
• المشـــاركـات » 47
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر »
• الـجـنـس »
• نقـاط التقييم » 17
iRock صـاعـد

iRock غير متواجد حالياً



افتراضي مشكلة في Procedure لـSkill Scroll



كود:
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 ; 02-12-2019 الساعة 01:15 AM

رد مع اقتباس
إعلانات google

قديم 01-12-2019, 08:08 PM   #2

محمد منتصر
عضو لامع



الصورة الرمزية محمد منتصر


• الانـتـسـاب » Dec 2010
• رقـم العـضـويـة » 77696
• المشـــاركـات » 1,134
• الـدولـة » Cairo
• الـهـوايـة » Developer Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 33
محمد منتصر صـاعـد

محمد منتصر غير متواجد حالياً



افتراضي رد: مشكلة في Procedure لـSkill Scroll



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


توقيع محمد منتصر :





Edit By :- [GM]T0P


رد مع اقتباس
قديم 02-12-2019, 01:16 AM   #3

iRock
عضو جديد



الصورة الرمزية iRock


• الانـتـسـاب » Feb 2010
• رقـم العـضـويـة » 69996
• المشـــاركـات » 47
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر »
• الـجـنـس »
• نقـاط التقييم » 17
iRock صـاعـد

iRock غير متواجد حالياً



افتراضي رد: مشكلة في Procedure لـSkill Scroll



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




رد مع اقتباس
قديم 02-12-2019, 06:46 PM   #4

محمد منتصر
عضو لامع



الصورة الرمزية محمد منتصر


• الانـتـسـاب » Dec 2010
• رقـم العـضـويـة » 77696
• المشـــاركـات » 1,134
• الـدولـة » Cairo
• الـهـوايـة » Developer Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 33
محمد منتصر صـاعـد

محمد منتصر غير متواجد حالياً



افتراضي رد: مشكلة في Procedure لـSkill Scroll



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


توقيع محمد منتصر :





Edit By :- [GM]T0P


رد مع اقتباس
قديم 02-12-2019, 09:56 PM   #5

iRock
عضو جديد



الصورة الرمزية iRock


• الانـتـسـاب » Feb 2010
• رقـم العـضـويـة » 69996
• المشـــاركـات » 47
• الـدولـة »
• الـهـوايـة »
• اسـم الـسـيـرفـر »
• الـجـنـس »
• نقـاط التقييم » 17
iRock صـاعـد

iRock غير متواجد حالياً



افتراضي رد: مشكلة في Procedure لـSkill Scroll



اقتباس:
المشاركة الأصلية كتبت بواسطة محمد منتصر عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
شوف التابل عندك 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
الف شكر ليك يا ريس علي تفاعلك و مساعدتك




رد مع اقتباس
قديم 03-12-2019, 10:42 PM   #6

محمد منتصر
عضو لامع



الصورة الرمزية محمد منتصر


• الانـتـسـاب » Dec 2010
• رقـم العـضـويـة » 77696
• المشـــاركـات » 1,134
• الـدولـة » Cairo
• الـهـوايـة » Developer Private Server
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 33
محمد منتصر صـاعـد

محمد منتصر غير متواجد حالياً



افتراضي رد: مشكلة في Procedure لـSkill Scroll



اقتباس:
المشاركة الأصلية كتبت بواسطة iRock عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


طبعا التابل كلها موجوده يا باشا و ال 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
الف شكر ليك يا ريس علي تفاعلك و مساعدتك
بالظبط ده كده صح اهو محدد انه هيعمل كريت لتابل كل واحد باسم بيلد اهو ومحدد هو عايز ايه لكن الل فوق مش كاتب اي حاجه وكاتب اسم الداتا بيز حتي هتلاقيه مختلف عندك انت فمش هيلاقي مكان يشتغل فيه وهيجيب ايرور


توقيع محمد منتصر :





Edit By :- [GM]T0P


رد مع اقتباس
إضافة رد


يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
 

ضوابط المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code متاحة
كود [IMG] متاحة
كود HTML معطلة

الانتقال السريع

المواضيع المتشابهه
الموضوع كاتب الموضوع المنتدى الردود آخر مشاركة
Silk Scroll Procedure BlackClover قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 2 07-04-2020 07:42 PM
حصريا لاول مرة علي سيلكرود4عرب : Blue Devil Scroll Procedure Story-Sro Owner قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة 26 18-09-2018 06:48 AM
مشكلة فى ال Plus Scroll testmis قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 9 18-08-2018 11:21 PM
مشكلة فى FB scroll OoMasterOo قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة 4 27-10-2017 05:14 PM
Full Useful Procedure Scroll Dev. iLegend قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة 20 16-07-2017 05:38 PM


الساعة الآن 11:28 AM.