عرض مشاركة واحدة
قديم 02-12-2019, 09:56 PM   #5

iRock
عضو جديد



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


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

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

159  



افتراضي رد: مشكلة في 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
الف شكر ليك يا ريس علي تفاعلك و مساعدتك




رد مع اقتباس