مشاهدة النسخة كاملة : محتاج شويه Query
joesuef
08-04-2017, 08:49 PM
مسح جميع الجيلدات ال ف الجيم
مسح الناس ال واخده Fortress War =)
MORJANA
08-04-2017, 09:06 PM
:bash:
رقم 1 ياريت تتابع الموضوع التاني بتاعك اللي هنا الأول
http://www.silkroad4arab.com/vb/showthread.php?t=614551
:nono2::nono2::nono2:
رقم 2 ياريت تقرأ قوانين القسم كويس قبل ما تعمل مواضيع تاني
11-عدم وضع اكثر من موضوعين فى اليوم لتخفيف الضغط على مشرفينا فى القسم.
23 - حضرتك لك كحد اقصى موضوعين فى اليوم طبقا للماده رقم 11
بس حضرتك لما تعمل موضوع مينفعش تعمل موضوع تانى غير لما المشكلة الاولى تتحل ,, اى موضوع مخالف للماده 23 هينقل لقسم المكرر و المخالف ..
MORJANA
08-04-2017, 09:10 PM
[B]الجيلد
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_Guild] DROP CONSTRAINT [FK__Guild__AlliedClans]
GO
/****** Object: Table [dbo].[_Guild] Script Date: 08/4/2017 8:08:37 PM ******/
DROP TABLE [dbo].[_Guild]
GO
/****** Object: Table [dbo].[_Guild] Script Date: 08/4/2017 8:08:37 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_Guild](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](64) NOT NULL,
[Lvl] [tinyint] NOT NULL,
[GatheredSP] [int] NOT NULL,
[FoundationDate] [smalldatetime] NOT NULL,
[Alliance] [int] NULL,
[MasterCommentTitle] [varchar](129) NULL,
[MasterComment] [varchar](2049) NULL,
[int] NULL,
[Gold] [bigint] NOT NULL DEFAULT (0),
[LastCrestRev] [int] NOT NULL DEFAULT (0),
[CurCrestRev] [int] NOT NULL DEFAULT (0),
[MercenaryAttr] [tinyint] NOT NULL DEFAULT (0),
CONSTRAINT [PK__Guild] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX__Guild] UNIQUE NONCLUSTERED
(
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[_Guild] WITH CHECK ADD CONSTRAINT [FK__Guild__AlliedClans] FOREIGN KEY([Alliance])
REFERENCES [dbo].[_AlliedClans] ([ID])
GO
ALTER TABLE [dbo].[_Guild] CHECK CONSTRAINT [FK__Guild__AlliedClans]
GO
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildChest] DROP CONSTRAINT [FK__GuildChest_Guild]
GO
/****** Object: Table [dbo].[_GuildChest] Script Date: 08/4/2017 8:08:51 PM ******/
DROP TABLE [dbo].[_GuildChest]
GO
/****** Object: Table [dbo].[_GuildChest] Script Date: 08/4/2017 8:08:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_GuildChest](
[GuildID] [int] NOT NULL,
[Slot] [tinyint] NOT NULL,
[ItemID] [bigint] NULL,
CONSTRAINT [PK__GuildChest] PRIMARY KEY CLUSTERED
(
[GuildID] ASC,
[Slot] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[_GuildChest] WITH NOCHECK ADD CONSTRAINT [FK__GuildChest_Guild] FOREIGN KEY([GuildID])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildChest] CHECK CONSTRAINT [FK__GuildChest_Guild]
GO
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [FK__GuildMember__Guild]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [DF___GuildMem__Siege__40C9606C]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [DF___GuildMem__RefOb__0C326F40]
GO
/****** Object: Table [dbo].[_GuildMember] Script Date: 08/4/2017 8:09:23 PM ******/
DROP TABLE [dbo].[_GuildMember]
GO
/****** Object: Table [dbo].[_GuildMember] Script Date: 08/4/2017 8:09:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_GuildMember](
[GuildID] [int] NOT NULL,
[CharID] [int] NOT NULL,
[CharName] [varchar](64) NOT NULL,
[MemberClass] [tinyint] NOT NULL,
[CharLevel] [tinyint] NOT NULL,
[GP_Donation] [int] NOT NULL,
[JoinDate] [smalldatetime] NOT NULL,
[Permission] [int] NULL,
[Contribution] [int] NULL,
[GuildWarKill] [int] NULL,
[GuildWarKilled] [int] NULL,
[Nickname] [varchar](64) NULL,
[RefObjID] [int] NULL,
[SiegeAuthority] [tinyint] NULL,
CONSTRAINT [PK__GuildMember] PRIMARY KEY CLUSTERED
(
[GuildID] ASC,
[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[_GuildMember] ADD DEFAULT (0) FOR [RefObjID]
GO
ALTER TABLE [dbo].[_GuildMember] ADD DEFAULT (0) FOR [SiegeAuthority]
GO
ALTER TABLE [dbo].[_GuildMember] WITH CHECK ADD CONSTRAINT [FK__GuildMember__Guild] FOREIGN KEY([GuildID])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildMember] CHECK CONSTRAINT [FK__GuildMember__Guild]
GO
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildWar] DROP CONSTRAINT [FK__GuildWar__Guild1]
GO
ALTER TABLE [dbo].[_GuildWar] DROP CONSTRAINT [FK__GuildWar__Guild]
GO
/****** Object: Table [dbo].[_GuildWar] Script Date: 08/4/2017 8:09:40 PM ******/
DROP TABLE [dbo].[_GuildWar]
GO
/****** Object: Table [dbo].[_GuildWar] Script Date: 08/4/2017 8:09:40 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_GuildWar](
[ID] [int] IDENTITY(1,1) NOT NULL,
[WarType] [tinyint] NOT NULL,
[VictoryPointIndex] [tinyint] NOT NULL,
[LodgedGold] [int] NOT NULL,
[WarEndTime] [smalldatetime] NULL,
[Guild1] [int] NOT NULL,
[Guild2] [int] NOT NULL,
[PointGain1] [int] NOT NULL,
[PointGain2] [int] NOT NULL,
[Data1] [int] NOT NULL,
[Data2] [int] NOT NULL,
CONSTRAINT [PK__GuildWar] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[_GuildWar] WITH CHECK ADD CONSTRAINT [FK__GuildWar__Guild] FOREIGN KEY([Guild1])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildWar] CHECK CONSTRAINT [FK__GuildWar__Guild]
GO
ALTER TABLE [dbo].[_GuildWar] WITH CHECK ADD CONSTRAINT [FK__GuildWar__Guild1] FOREIGN KEY([Guild2])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildWar] CHECK CONSTRAINT [FK__GuildWar__Guild1]
GO
FTW
/*** Simple query for Fortress Owner Declaration By Buddha ***/
USE [SRO_VT_SHARD]UPDATE _SiegeFortress
SET GuildID=0
joesuef
08-04-2017, 09:10 PM
:bash:
رقم 1 ياريت تتابع الموضوع التاني بتاعك اللي هنا الأول
http://www.silkroad4arab.com/vb/showthread.php?t=614551
:nono2::nono2::nono2:
رقم 2 ياريت تقرأ قوانين القسم كويس قبل ما تعمل مواضيع تاني
11-عدم وضع اكثر من موضوعين فى اليوم لتخفيف الضغط على مشرفينا فى القسم.
23 - حضرتك لك كحد اقصى موضوعين فى اليوم طبقا للماده رقم 11
بس حضرتك لما تعمل موضوع مينفعش تعمل موضوع تانى غير لما المشكلة الاولى تتحل ,, اى موضوع مخالف للماده 23 هينقل لقسم المكرر و المخالف ..
تمام انا عملت موضعين بس ؟
MORJANA
08-04-2017, 09:16 PM
تمام انا عملت موضعين بس ؟
ممنوع حضرتك تعمل اكتر من موضوع في يوم واحد أستنى ع الأقل الموضوع الأول يتم حله :lamo:
joesuef
08-04-2017, 09:17 PM
[B]الجيلد
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_Guild] DROP CONSTRAINT [FK__Guild__AlliedClans]
GO
/****** Object: Table [dbo].[_Guild] Script Date: 08/4/2017 8:08:37 PM ******/
DROP TABLE [dbo].[_Guild]
GO
/****** Object: Table [dbo].[_Guild] Script Date: 08/4/2017 8:08:37 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_Guild](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](64) NOT NULL,
[Lvl] [tinyint] NOT NULL,
[GatheredSP] [int] NOT NULL,
[FoundationDate] [smalldatetime] NOT NULL,
[Alliance] [int] NULL,
[MasterCommentTitle] [varchar](129) NULL,
[MasterComment] [varchar](2049) NULL,
[int] NULL,
[Gold] [bigint] NOT NULL DEFAULT (0),
[LastCrestRev] [int] NOT NULL DEFAULT (0),
[CurCrestRev] [int] NOT NULL DEFAULT (0),
[MercenaryAttr] [tinyint] NOT NULL DEFAULT (0),
CONSTRAINT [PK__Guild] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX__Guild] UNIQUE NONCLUSTERED
(
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[_Guild] WITH CHECK ADD CONSTRAINT [FK__Guild__AlliedClans] FOREIGN KEY([Alliance])
REFERENCES [dbo].[_AlliedClans] ([ID])
GO
ALTER TABLE [dbo].[_Guild] CHECK CONSTRAINT [FK__Guild__AlliedClans]
GO
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildChest] DROP CONSTRAINT [FK__GuildChest_Guild]
GO
/****** Object: Table [dbo].[_GuildChest] Script Date: 08/4/2017 8:08:51 PM ******/
DROP TABLE [dbo].[_GuildChest]
GO
/****** Object: Table [dbo].[_GuildChest] Script Date: 08/4/2017 8:08:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_GuildChest](
[GuildID] [int] NOT NULL,
[Slot] [tinyint] NOT NULL,
[ItemID] [bigint] NULL,
CONSTRAINT [PK__GuildChest] PRIMARY KEY CLUSTERED
(
[GuildID] ASC,
[Slot] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[_GuildChest] WITH NOCHECK ADD CONSTRAINT [FK__GuildChest_Guild] FOREIGN KEY([GuildID])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildChest] CHECK CONSTRAINT [FK__GuildChest_Guild]
GO
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [FK__GuildMember__Guild]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [DF___GuildMem__Siege__40C9606C]
GO
ALTER TABLE [dbo].[_GuildMember] DROP CONSTRAINT [DF___GuildMem__RefOb__0C326F40]
GO
/****** Object: Table [dbo].[_GuildMember] Script Date: 08/4/2017 8:09:23 PM ******/
DROP TABLE [dbo].[_GuildMember]
GO
/****** Object: Table [dbo].[_GuildMember] Script Date: 08/4/2017 8:09:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_GuildMember](
[GuildID] [int] NOT NULL,
[CharID] [int] NOT NULL,
[CharName] [varchar](64) NOT NULL,
[MemberClass] [tinyint] NOT NULL,
[CharLevel] [tinyint] NOT NULL,
[GP_Donation] [int] NOT NULL,
[JoinDate] [smalldatetime] NOT NULL,
[Permission] [int] NULL,
[Contribution] [int] NULL,
[GuildWarKill] [int] NULL,
[GuildWarKilled] [int] NULL,
[Nickname] [varchar](64) NULL,
[RefObjID] [int] NULL,
[SiegeAuthority] [tinyint] NULL,
CONSTRAINT [PK__GuildMember] PRIMARY KEY CLUSTERED
(
[GuildID] ASC,
[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[_GuildMember] ADD DEFAULT (0) FOR [RefObjID]
GO
ALTER TABLE [dbo].[_GuildMember] ADD DEFAULT (0) FOR [SiegeAuthority]
GO
ALTER TABLE [dbo].[_GuildMember] WITH CHECK ADD CONSTRAINT [FK__GuildMember__Guild] FOREIGN KEY([GuildID])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildMember] CHECK CONSTRAINT [FK__GuildMember__Guild]
GO
USE [SRO_VT_SHARD]
GO
ALTER TABLE [dbo].[_GuildWar] DROP CONSTRAINT [FK__GuildWar__Guild1]
GO
ALTER TABLE [dbo].[_GuildWar] DROP CONSTRAINT [FK__GuildWar__Guild]
GO
/****** Object: Table [dbo].[_GuildWar] Script Date: 08/4/2017 8:09:40 PM ******/
DROP TABLE [dbo].[_GuildWar]
GO
/****** Object: Table [dbo].[_GuildWar] Script Date: 08/4/2017 8:09:40 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_GuildWar](
[ID] [int] IDENTITY(1,1) NOT NULL,
[WarType] [tinyint] NOT NULL,
[VictoryPointIndex] [tinyint] NOT NULL,
[LodgedGold] [int] NOT NULL,
[WarEndTime] [smalldatetime] NULL,
[Guild1] [int] NOT NULL,
[Guild2] [int] NOT NULL,
[PointGain1] [int] NOT NULL,
[PointGain2] [int] NOT NULL,
[Data1] [int] NOT NULL,
[Data2] [int] NOT NULL,
CONSTRAINT [PK__GuildWar] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[_GuildWar] WITH CHECK ADD CONSTRAINT [FK__GuildWar__Guild] FOREIGN KEY([Guild1])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildWar] CHECK CONSTRAINT [FK__GuildWar__Guild]
GO
ALTER TABLE [dbo].[_GuildWar] WITH CHECK ADD CONSTRAINT [FK__GuildWar__Guild1] FOREIGN KEY([Guild2])
REFERENCES [dbo].[_Guild] ([ID])
GO
ALTER TABLE [dbo].[_GuildWar] CHECK CONSTRAINT [FK__GuildWar__Guild1]
GO
FTW
/*** Simple query for Fortress Owner Declaration By Buddha ***/
USE [SRO_VT_SHARD]UPDATE _SiegeFortress
SET GuildID=0
كله شغال معاده واحده اول واحده بتجبلي
Msg 3726, Level 16, State 1, Line 8
Could not drop object 'dbo._Guild' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 21
There is already an object named '_Guild' in the database.
MORJANA
08-04-2017, 09:19 PM
كليك يمين على الـ Table --> _Guild و اعمله Delete
و بعدين جرب تعمل الكويري تاني
joesuef
08-04-2017, 09:21 PM
كليك يمين على الـ Table --> _Guild و اعمله Delete
و بعدين جرب تعمل الكويري تاني
Table --> اصلا فاضي مفهوش حاجه امسحها ؟
MORJANA
08-04-2017, 09:28 PM
Table --> اصلا فاضي مفهوش حاجه امسحها ؟
يا باشا اعمل ديليت للـ Table نفسها و بعدين أعمل الكويري
joesuef
08-04-2017, 09:29 PM
يا باشا اعمل ديليت للـ Table نفسها و بعدين أعمل الكويري
مش راضي يعمل ديليت اصلا =ي
MORJANA
08-04-2017, 09:35 PM
مش راضي يعمل ديليت اصلا =ي
طيب كليك يمين على _Guild و Edit all Row
و أمسح كل اللي فيها و بعدين حط اللاين ده
ما تنساش تقفل الـ Sql و تفتحه تاني عشان يقرا الـ Tables تاني
0 dummy 1 0 2008-11-10 08:46:00 0 NULL NULL 0 0 0 0 0
joesuef
08-04-2017, 09:39 PM
طيب كليك يمين على _Guild و Edit all Row
و أمسح كل اللي فيها و بعدين حط اللاين ده
ما تنساش تقفل الـ Sql و تفتحه تاني عشان يقرا الـ Tables تاني
0 dummy 1 0 2008-11-10 08:46:00 0 NULL NULL 0 0 0 0 0
http://i.epvpimg.com/PVIhdab.png ?
MORJANA
08-04-2017, 09:44 PM
http://i.epvpimg.com/PVIhdab.png ?
أعمل Execute و بعدين أعمل Delete تاني :cowboy:
joesuef
08-04-2017, 09:47 PM
أعمل Execute و بعدين أعمل Delete تاني :cowboy:
في بيتمسح في بيجبلي كده
http://i.epvpimg.com/7TTadab.png
MORJANA
08-04-2017, 09:48 PM
طب أقفل الـ SQL و أفتحه تاني و أعمل كده
هيطلعلك كويري دوس F5 على طول
https://i58.servimg.com/u/f58/11/58/76/94/untitl10.png
joesuef
08-04-2017, 09:51 PM
طب أقفل الـ SQL و أفتحه تاني و أعمل كده
هيطلعلك كويري دوس F5 على طول
https://i58.servimg.com/u/f58/11/58/76/94/untitl10.png
?
Msg 3726, Level 16, State 1, Line 8
Could not drop object 'dbo._Guild' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 21
There is already an object named '_Guild' in the database.
_AlliedClans ده هوا سبب معرفش ايه حل بقا ؟
MORJANA
08-04-2017, 10:19 PM
?
Msg 3726, Level 16, State 1, Line 8
Could not drop object 'dbo._Guild' because it is referenced by a FOREIGN KEY constraint.
Msg 2714, Level 16, State 6, Line 21
There is already an object named '_Guild' in the database.
_AlliedClans ده هوا سبب معرفش ايه حل بقا ؟
طب جرب تمسح الـ Lines بإيدك كدخ :mexicano:
joesuef
08-04-2017, 10:28 PM
طب جرب تمسح الـ Lines بإيدك كدخ :mexicano:
جربت كل حاجه مش نافع تيجي طيب تيم تشوفه ؟
joesuef
08-04-2017, 11:17 PM
مفيش حل يعني ولا ايه ؟
MORJANA
09-04-2017, 01:22 AM
وريني صورة كده من الـ Table
joesuef
09-04-2017, 02:30 AM
وريني صورة كده من الـ Table
http://i.epvpimg.com/qJjHcab.png
MORJANA
09-04-2017, 04:08 AM
حضرتك دخلت على الـ Design مش الــ Edit all Row !!
جرب كده تدوس كليك يمين على التيبل نفسها dbo._Guild و تختار Delete
joesuef
09-04-2017, 09:37 AM
حضرتك دخلت على الـ Design مش الــ Edit all Row !!
جرب كده تدوس كليك يمين على التيبل نفسها dbo._Guild و تختار Delete
اتفضل
http://i.epvpimg.com/LIRRdab.png
MORJANA
09-04-2017, 08:43 PM
طب ركز معايا ثانية
هتعمل الكويري ده :balloon:قبل ما تمسح الـTable و بعدين تمسحها
ALTER TABLE MyTable NOCHECK CONSTRAINT MyConstraint
و بعد ما تتمسح هتكريتها تاني بالكويري ده
USE [SRO_VT_SHARD]
GO
/****** Object: Table [dbo].[_Guild] Script Date: 09/4/2017 7:44:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_Guild](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](64) NOT NULL,
[Lvl] [tinyint] NOT NULL,
[GatheredSP] [int] NOT NULL,
[FoundationDate] [smalldatetime] NOT NULL,
[Alliance] [int] NULL,
[MasterCommentTitle] [varchar](129) NULL,
[MasterComment] [varchar](2049) NULL,
[Booty] [int] NULL,
[Gold] [bigint] NOT NULL DEFAULT (0),
[LastCrestRev] [int] NOT NULL DEFAULT (0),
[CurCrestRev] [int] NOT NULL DEFAULT (0),
[MercenaryAttr] [tinyint] NOT NULL DEFAULT (0),
CONSTRAINT [PK__Guild] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX__Guild] UNIQUE NONCLUSTERED
(
[Name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[_Guild] WITH CHECK ADD CONSTRAINT [FK__Guild__AlliedClans] FOREIGN KEY([Alliance])
REFERENCES [dbo].[_AlliedClans] ([ID])
GO
ALTER TABLE [dbo].[_Guild] CHECK CONSTRAINT [FK__Guild__AlliedClans]
GO
و بعدين تقفل الـ SQL و تفتحه تاني و تعمل الكويري ده
ALTER TABLE MyTable CHECK CONSTRAINT MyConstraint
Mahmoud Rashwan
15-04-2017, 10:06 PM
@@
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc