Z.e.K.o
14-11-2012, 10:44 PM
السلام عليكم ورحمة الله وبركاته
انا النهارده جايبلكو الكود ده عشان لو حد عاوز يخلى السيرفر كله قرعه من غير موبس :drinks_wine:
بمعنى ان الكوده ده بيمسح جميع الموبس من كل المدن
USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO
USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
[ID] [nchar](10) NULL
) ON [PRIMARY]
GO
INSERT INTO Region (ID)
select
_RefRegion.wRegionID
from
_RefRegion
where
/* Set JUPITER name here like 'JUPITER'*/
_RefRegion.ContinentName like 'JUPITER'
GO
delete FROM Tab_RefNest
WHERE EXISTS (SELECT ID FROM Region WHERE ID = nRegionDBID)
USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO
انا النهارده جايبلكو الكود ده عشان لو حد عاوز يخلى السيرفر كله قرعه من غير موبس :drinks_wine:
بمعنى ان الكوده ده بيمسح جميع الموبس من كل المدن
USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO
USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
[ID] [nchar](10) NULL
) ON [PRIMARY]
GO
INSERT INTO Region (ID)
select
_RefRegion.wRegionID
from
_RefRegion
where
/* Set JUPITER name here like 'JUPITER'*/
_RefRegion.ContinentName like 'JUPITER'
GO
delete FROM Tab_RefNest
WHERE EXISTS (SELECT ID FROM Region WHERE ID = nRegionDBID)
USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO