罗兰攻城
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GCGuild]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GCGuild]
GO
CREATE TABLE [dbo].[GCGuild] (
[IDX] [int] NOT NULL ,
[GuildName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GuildIdx] [int] NOT NULL ,
[GuildMZName] [varchar] (10) NOT NULL
) ON [PRIMARY]
GO
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (100,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (101,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (102,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (103,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (104,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (200,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (201,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (202,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (203,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (204,' ',0,' ')