大虾们，帮我看阿奎那这段SQL语句问题出在哪里了

最新推荐文章于 2024-07-19 17:34:15 发布
最新推荐文章于 2024-07-19 17:34:15 发布
阅读量1.1k 收藏
点赞数
文章标签： sql null table object delete email
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mygoda/article/details/2628421
版权

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Delete_Group]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [cn3a060].[Delete_Group] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[InsertGroup_TextTemp]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [cn3a060].[InsertGroup_TextTemp] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[update_Group_Ad]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [cn3a060].[update_Group_Ad] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Delete_GuaranteeOrder]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [cn3a060].[Delete_GuaranteeOrder] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Game_Duty_Area_Server]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [cn3a060].[Game_Duty_Area_Server] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Delete_UserInfo]') and OBJECTPROPERTY(id, N'IsTrigger') = 1) drop trigger [cn3a060].[Delete_UserInfo] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[insert_GroupPerson]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [cn3a060].[insert_GroupPerson] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[update_GroupPerson]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [cn3a060].[update_GroupPerson] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[update_GroupPerson_Admin]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [cn3a060].[update_GroupPerson_Admin] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[update_GroupPerson_Show]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [cn3a060].[update_GroupPerson_Show] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Admin_Person]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Admin_Person] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[FriendLink]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[FriendLink] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[GamePro_BuySell]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[GamePro_BuySell] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Game_Job]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Game_Job] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Game_Work]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Game_Work] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[GroupColor]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[GroupColor] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[GroupPerson]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[GroupPerson] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Group_Ad]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Group_Ad] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Group_BBS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Group_BBS] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Group_Img]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Group_Img] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Group_PowerLevel_News]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Group_PowerLevel_News] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Group_Style]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Group_Style] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Group_TextTemp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Group_TextTemp] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[GuaranteeOrder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[GuaranteeOrder] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[MeGroupMoney]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[MeGroupMoney] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[News]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[News] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[OperateOrder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[OperateOrder] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[PL_Duty]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[PL_Duty] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[PowerLevel_Ask]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[PowerLevel_Ask] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[PowerLevel_Re]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[PowerLevel_Re] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[RightWrong]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[RightWrong] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Service_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Service_User] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Set_Game_Area]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Set_Game_Area] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Set_Game_Server]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Set_Game_Server] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Set_Games]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Set_Games] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Set_city]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Set_city] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Set_province]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Set_province] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[System_Set]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[System_Set] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[UserInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[UserInfo] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[Vote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[Vote] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[YjTs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[YjTs] GO

if exists (select * from dbo.sysobjects where id = object_id(N'[cn3a060].[dtproperties]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [cn3a060].[dtproperties] GO

CREATE TABLE [cn3a060].[Admin_Person] (  [LoginName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [PersonName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [LoginPassword] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [PersonCode] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [PersonType] [tinyint] NOT NULL ,  [PersonTypeName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [PersonFlg] [bit] NOT NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[FriendLink] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [LinkName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [LinkPic] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,  [LinkUrl] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Type] [tinyint] NULL ,  [DefaultShow] [tinyint] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[GamePro_BuySell] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [Game_Id] [int] NOT NULL ,  [Area_Id] [int] NOT NULL ,  [Server_Id] [int] NOT NULL ,  [BuySell_Action] [tinyint] NOT NULL ,  [BuySell_Flag] [tinyint] NOT NULL ,  [Title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,  [MoneyText] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [FullName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Province] [int] NOT NULL ,  [City] [int] NOT NULL ,  [QQMsn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,  [Show] [tinyint] NULL ,  [AddTime] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Game_Job] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [CompanyName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GameName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [JobName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [JobNum] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Sex] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Age] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [TimeOld] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,  [FullName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Province] [int] NOT NULL ,  [City] [int] NOT NULL ,  [QQMsn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,  [Show] [tinyint] NULL ,  [AddTime] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Game_Work] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [FullName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Age] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Sex] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [WorkName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Title] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Province] [int] NOT NULL ,  [City] [int] NOT NULL ,  [QQMsn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,  [Show] [tinyint] NULL ,  [AddTime] [datetime] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[GroupColor] (  [Color_Id] [int] IDENTITY (1, 1) NOT NULL ,  [Color_Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Color_Text] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[GroupPerson] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [LoginName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [LoginPwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Question] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Answer] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [FullName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Sex] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Code] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Oicq1] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Oicq2] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,  [Oicq3] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,  [Oicq4] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,  [Province] [int] NOT NULL ,  [City] [int] NOT NULL ,  [Address] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Money_Set] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Money_Person] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Money_Code] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GroupName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GroupPersonNum] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GroupGame] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GroupStyle] [int] NOT NULL ,  [RegTime] [datetime] NULL ,  [LastLoginTime] [datetime] NULL ,  [PhoneShow] [tinyint] NULL ,  [Jifen] [decimal](9, 1) NULL ,  [GiveMoney] [tinyint] NULL ,  [PersonFlag] [tinyint] NULL ,  [GroupJianjie] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [GroupGongGao] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [GroupPowerLevel] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [JifenShow] [tinyint] NULL ,  [OneShow] [tinyint] NULL ,  [GroupImg] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Group_Ad] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [GroupId] [int] NOT NULL ,  [JiFen] [int] NOT NULL ,  [Days] [int] NOT NULL ,  [AdMode] [tinyint] NOT NULL ,  [AdTitle] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [AddTime] [datetime] NULL ,  [Show] [tinyint] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Group_BBS] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [GroupId] [int] NOT NULL ,  [UserQM] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [User_Content] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [User_AddTime] [datetime] NULL ,  [Group_Content] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,  [Group_AddTime] [datetime] NULL ,  [Show] [tinyint] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Group_Img] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [GroupId] [int] NOT NULL ,  [JiFen] [int] NOT NULL ,  [SayContent] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,  [AddTime] [datetime] NULL ,  [Show] [tinyint] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Group_PowerLevel_News] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [GroupId] [int] NOT NULL ,  [NewsTitle] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [NewsContent] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,  [NewShow] [tinyint] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Group_Style] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [StyleName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [StyleFlag] [tinyint] NOT NULL ,  [StylePic] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,  [StyleMoney] [decimal](9, 1) NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Group_TextTemp] (  [GroupId] [int] NOT NULL ,  [GroupJianjie] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [GroupGongGao] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [GroupPowerLevel] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [Show] [tinyint] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[GuaranteeOrder] (  [OrderNum] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GameName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [ServerArea] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [CharName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [AccountName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [PL_Days] [int] NOT NULL ,  [PL_Duty] [varchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [OtherDay] [int] NULL ,  [ShortDuly] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,  [StartTime] [datetime] NULL ,  [EndTime] [datetime] NULL ,  [StartMode] [tinyint] NOT NULL ,  [UserQQ] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,  [UserMobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,  [UserPhone] [varchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,  [GroupName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GroupId] [int] NOT NULL ,  [OrderMoney] [decimal](9, 2) NOT NULL ,  [KartWhere] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [BackMode] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [XieYi] [nvarchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [AddTime] [datetime] NULL ,  [YanshouTime] [datetime] NULL ,  [danbaokefu] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,  [StartImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,  [EndImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,  [OrderFlag] [tinyint] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[MeGroupMoney] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [OrderNum] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [GroupId] [int] NOT NULL ,  [ShijiMoney] [decimal](9, 2) NOT NULL ,  [HuiruMoney] [decimal](9, 2) NOT NULL ,  [MoneyFlag] [tinyint] NULL ,  [Money_Blank] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Money_Person] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Money_Code] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [ServiceUser] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Money_Content] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,  [OperateTime] [datetime] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[News] (  [new_id] [int] IDENTITY (1, 1) NOT NULL ,  [new_title] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [new_content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,  [new_time] [datetime] NULL ,  [new_flag] [tinyint] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[OperateOrder] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [OrderNum] [varchar] (300) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [ServiceUser] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [OperateSay] [varchar] (500) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [OperateTime] [datetime] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[PL_Duty] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [Game_Id] [int] NOT NULL ,  [Duty_Name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[PowerLevel_Ask] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [Game_Id] [int] NOT NULL ,  [GameLine] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [UserQQ] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,  [UserPhone] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,  [AskMode] [tinyint] NOT NULL ,  [AskContent] [nvarchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Show] [tinyint] NULL ,  [AddTime] [datetime] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[PowerLevel_Re] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [AskId] [int] NOT NULL ,  [GroupId] [int] NOT NULL ,  [ReMoney] [decimal](9, 3) NOT NULL ,  [ReContent] [nvarchar] (3000) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [AddTime] [datetime] NULL ,  [Show] [tinyint] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[RightWrong] (  [AutoID] [int] IDENTITY (1, 1) NOT NULL ,  [Number] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [NumberName] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Type] [tinyint] NOT NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Service_User] (  [AutoID] [int] IDENTITY (1, 1) NOT NULL ,  [Name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Content] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Service_For] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [Show] [tinyint] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Set_Game_Area] (  [Area_Id] [int] IDENTITY (1, 1) NOT NULL ,  [Game_Id] [int] NOT NULL ,  [Area_Name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Set_Game_Server] (  [Server_Id] [int] IDENTITY (1, 1) NOT NULL ,  [Game_Id] [int] NOT NULL ,  [Area_Id] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Server_Name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Set_Games] (  [Game_Id] [int] IDENTITY (111, 1) NOT NULL ,  [Game_Name] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [Game_Color] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,  [Powerlevel] [bit] NULL ,  [BuySell] [bit] NULL ,  [FirstName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [PicImg] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [ChickNum] [int] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Set_city] (  [id] [int] IDENTITY (1, 1) NOT NULL ,  [shiname] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,  [shiNo] [int] NULL ,  [Shengid] [int] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Set_province] (  [id] [int] IDENTITY (1, 1) NOT NULL ,  [shengname] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,  [shengNo] [int] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[System_Set] (  [Sys_Id] [int] IDENTITY (1, 1) NOT NULL ,  [Sys_KeyWords] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,  [Sys_Jmgzs] [int] NULL ,  [Sys_Dlxx] [int] NULL ,  [Sys_Jrdd] [int] NULL ,  [Sys_Zjyje] [int] NULL ,  [Sys_Jxdb] [int] NULL ,  [Sys_Wjqz] [int] NULL ,  [Sys_Gzszp] [int] NULL ,  [Sys_Tcjy] [int] NULL ,  [Sys_Zdd] [int] NULL ,  [Sys_BackJiFen] [decimal](9, 3) NULL ,  [Sys_BackMoney] [decimal](9, 3) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[UserInfo] (  [Email] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [PWD] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[Vote] (  [v_Id] [int] IDENTITY (1, 1) NOT NULL ,  [v_Title] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [v_Content] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [v_Show] [tinyint] NULL ) ON [PRIMARY] GO

CREATE TABLE [cn3a060].[YjTs] (  [AutoId] [int] IDENTITY (1, 1) NOT NULL ,  [UserName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [UserAge] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [UserSex] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [UserTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [UserWeb] [varchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [UserContent] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,  [UserShow] [tinyint] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

CREATE TABLE [cn3a060].[dtproperties] (  [id] [int] NOT NULL ,  [objectid] [int] NULL ,  [property] [varchar] (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,  [value] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,  [uvalue] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,  [lvalue] [image] NULL ,  [version] [int] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Admin_Person] WITH NOCHECK ADD  CONSTRAINT [PK_Admin_Person] PRIMARY KEY  CLUSTERED  (   [LoginName]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[FriendLink] WITH NOCHECK ADD  CONSTRAINT [PK_FriendLink] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[GamePro_BuySell] WITH NOCHECK ADD  CONSTRAINT [DF_GamePro_BuySell_Show] DEFAULT (1) FOR [Show],  CONSTRAINT [DF_GamePro_BuySell_AddTime] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [PK_GamePro_BuySell] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Game_Job] WITH NOCHECK ADD  CONSTRAINT [DF_Game_Job_Show] DEFAULT (1) FOR [Show],  CONSTRAINT [DF_Game_Job_AddTime] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [PK_Game_Job] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Game_Work] WITH NOCHECK ADD  CONSTRAINT [DF_Game_Work_Show] DEFAULT (1) FOR [Show],  CONSTRAINT [DF_Game_Work_AddTime] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [PK_Game_Work] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[GroupColor] WITH NOCHECK ADD  CONSTRAINT [PK_GroupColor] PRIMARY KEY  CLUSTERED  (   [Color_Id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[GroupPerson] WITH NOCHECK ADD  CONSTRAINT [DF_GroupPerson_RegTime] DEFAULT (getdate()) FOR [RegTime],  CONSTRAINT [DF_GroupPerson_LastLoginTime] DEFAULT (getdate()) FOR [LastLoginTime],  CONSTRAINT [DF_GroupPerson_PhoneShow] DEFAULT (1) FOR [PhoneShow],  CONSTRAINT [DF_GroupPerson_Jifen] DEFAULT (16) FOR [Jifen],  CONSTRAINT [DF_GroupPerson_GiveMoney] DEFAULT (1) FOR [GiveMoney],  CONSTRAINT [DF_GroupPerson_PersonFlag] DEFAULT (1) FOR [PersonFlag],  CONSTRAINT [DF_GroupPerson_GroupJianjie] DEFAULT (N'这个工作室很懒，什么都没输入！') FOR [GroupJianjie],  CONSTRAINT [DF_GroupPerson_GroupGongGao] DEFAULT (N'暂无公告！') FOR [GroupGongGao],  CONSTRAINT [DF_GroupPerson_GroupPowerLevel] DEFAULT (N'未填写主营代练！') FOR [GroupPowerLevel],  CONSTRAINT [DF_GroupPerson_JifenShow] DEFAULT (1) FOR [JifenShow],  CONSTRAINT [DF_GroupPerson_OneShow] DEFAULT (1) FOR [OneShow],  CONSTRAINT [DF_GroupPerson_GroupImg] DEFAULT ('Images/gzs_none.gif') FOR [GroupImg],  CONSTRAINT [PK_GroupPerson] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Group_Ad] WITH NOCHECK ADD  CONSTRAINT [DF__Group_Ad__JiFen__25518C17] DEFAULT (0) FOR [JiFen],  CONSTRAINT [DF__Group_Ad__AddTim__2645B050] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [DF__Group_Ad__Show__2739D489] DEFAULT (1) FOR [Show],   PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Group_BBS] WITH NOCHECK ADD  CONSTRAINT [DF_Group_BBS_User_AddTime] DEFAULT (getdate()) FOR [User_AddTime],  CONSTRAINT [DF_Group_BBS_Show] DEFAULT (1) FOR [Show],  CONSTRAINT [PK_Group_BBS] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Group_Img] WITH NOCHECK ADD  CONSTRAINT [DF__Group_Img__JiFen__18EBB532] DEFAULT (0) FOR [JiFen],  CONSTRAINT [DF__Group_Img__AddTi__19DFD96B] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [DF__Group_Img__Show__1AD3FDA4] DEFAULT (1) FOR [Show],   PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Group_PowerLevel_News] WITH NOCHECK ADD  CONSTRAINT [DF_Group_PowerLevel_News_NewShow] DEFAULT (1) FOR [NewShow],  CONSTRAINT [PK_Group_PowerLevel_News] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Group_Style] WITH NOCHECK ADD  CONSTRAINT [DF__Group_Sty__Style__2B0A656D] DEFAULT (50.0) FOR [StyleMoney],   PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Group_TextTemp] WITH NOCHECK ADD  CONSTRAINT [DF__Group_Text__Show__04AFB25B] DEFAULT (2) FOR [Show],  CONSTRAINT [PK__Group_TextTemp__03BB8E22] PRIMARY KEY  CLUSTERED  (   [GroupId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[GuaranteeOrder] WITH NOCHECK ADD  CONSTRAINT [DF__Guarantee__Other__6B24EA82] DEFAULT (0) FOR [OtherDay],  CONSTRAINT [DF__Guarantee__Start__6C190EBB] DEFAULT (1) FOR [StartMode],  CONSTRAINT [DF__Guarantee__AddTi__6D0D32F4] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [DF__Guarantee__Order__6E01572D] DEFAULT (1) FOR [OrderFlag],  CONSTRAINT [PK__GuaranteeOrder__6A30C649] PRIMARY KEY  CLUSTERED  (   [OrderNum]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[MeGroupMoney] WITH NOCHECK ADD  CONSTRAINT [DF__MeGroupMo__Money__00200768] DEFAULT (1) FOR [MoneyFlag],  CONSTRAINT [DF__MeGroupMo__Money__01142BA1] DEFAULT ('代练费') FOR [Money_Content],  CONSTRAINT [DF__MeGroupMo__Opera__02084FDA] DEFAULT (getdate()) FOR [OperateTime],  CONSTRAINT [PK__MeGroupMoney__7F2BE32F] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[News] WITH NOCHECK ADD  CONSTRAINT [DF_News_new_time] DEFAULT (getdate()) FOR [new_time],  CONSTRAINT [DF_News_new_flag] DEFAULT (1) FOR [new_flag],  CONSTRAINT [PK_News] PRIMARY KEY  CLUSTERED  (   [new_id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[OperateOrder] WITH NOCHECK ADD  CONSTRAINT [DF__OperateOr__Opera__05D8E0BE] DEFAULT (getdate()) FOR [OperateTime],   PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[PL_Duty] WITH NOCHECK ADD  CONSTRAINT [PK_PL_Duty] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[PowerLevel_Ask] WITH NOCHECK ADD  CONSTRAINT [DF_PowerLevel_Ask_AskMode] DEFAULT (1) FOR [AskMode],  CONSTRAINT [DF_PowerLevel_Ask_Show] DEFAULT (1) FOR [Show],  CONSTRAINT [DF_PowerLevel_Ask_AddTime] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [PK_PowerLevel_Ask] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[PowerLevel_Re] WITH NOCHECK ADD  CONSTRAINT [DF_PowerLevel_Re_AddTime] DEFAULT (getdate()) FOR [AddTime],  CONSTRAINT [DF_PowerLevel_Re_Show] DEFAULT (1) FOR [Show],  CONSTRAINT [PK_PowerLevel_Re] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[RightWrong] WITH NOCHECK ADD  CONSTRAINT [DF_RightWrong_Type] DEFAULT (1) FOR [Type],  CONSTRAINT [PK_RightWrong] PRIMARY KEY  CLUSTERED  (   [AutoID]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Service_User] WITH NOCHECK ADD  CONSTRAINT [DF_Service_User_Show] DEFAULT (1) FOR [Show],  CONSTRAINT [PK_Service_User] PRIMARY KEY  CLUSTERED  (   [AutoID]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Set_Game_Area] WITH NOCHECK ADD  CONSTRAINT [PK_Set_Game_Area] PRIMARY KEY  CLUSTERED  (   [Area_Id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Set_Game_Server] WITH NOCHECK ADD  CONSTRAINT [PK_Set_Game_Server] PRIMARY KEY  CLUSTERED  (   [Server_Id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Set_Games] WITH NOCHECK ADD  CONSTRAINT [DF_Set_Games_Powerlevel] DEFAULT (1) FOR [Powerlevel],  CONSTRAINT [DF_Set_Games_BuySell] DEFAULT (1) FOR [BuySell],  CONSTRAINT [DF_Set_Games_ChickNum] DEFAULT (0) FOR [ChickNum],  CONSTRAINT [PK_Set_Games] PRIMARY KEY  CLUSTERED  (   [Game_Id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Set_city] WITH NOCHECK ADD  CONSTRAINT [PK_Set_city] PRIMARY KEY  CLUSTERED  (   [id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Set_province] WITH NOCHECK ADD  CONSTRAINT [PK_Set_province] PRIMARY KEY  CLUSTERED  (   [id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[System_Set] WITH NOCHECK ADD  CONSTRAINT [DF_System_Set_Sys_Zdd] DEFAULT (100) FOR [Sys_Zdd],  CONSTRAINT [DF_System_Set_Sys_BackJiFen] DEFAULT (0.05) FOR [Sys_BackJiFen],  CONSTRAINT [DF_System_Set_Sys_BackMoney] DEFAULT (0.05) FOR [Sys_BackMoney],  CONSTRAINT [PK_System_Set] PRIMARY KEY  CLUSTERED  (   [Sys_Id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[UserInfo] WITH NOCHECK ADD  CONSTRAINT [PK_UserInfo] PRIMARY KEY  CLUSTERED  (   [Email]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[Vote] WITH NOCHECK ADD  CONSTRAINT [DF_Vote_v_Show] DEFAULT (1) FOR [v_Show],  CONSTRAINT [PK_Vote] PRIMARY KEY  CLUSTERED  (   [v_Id]  )  ON [PRIMARY] GO

ALTER TABLE [cn3a060].[YjTs] WITH NOCHECK ADD  CONSTRAINT [DF_YjTs_UserShow] DEFAULT (1) FOR [UserShow],  CONSTRAINT [PK_YjTs] PRIMARY KEY  CLUSTERED  (   [AutoId]  )  ON [PRIMARY] GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO

setuser N'cn3a060' GO

CREATE PROCEDURE [insert_GroupPerson]  (@LoginName  [varchar](50),   @LoginPwd  [varchar](50),   @Question  [varchar](100),   @Answer  [varchar](100),   @FullName  [varchar](50),   @Sex  [varchar](20),   @Code  [varchar](20),   @Tel  [varchar](50),   @Email  [varchar](100),   @Oicq1  [varchar](20),   @Oicq2  [varchar](20),   @Oicq3  [varchar](20),   @Oicq4  [varchar](20),   @Province  [int],   @City  [int],   @Address  [varchar](200),   @Money_Set  [varchar](100),   @Money_Person  [varchar](200),   @Money_Code  [varchar](25),   @GroupName  [varchar](100),   @GroupPersonNum  [varchar](20),   @GroupGame  [varchar](100),   @GroupStyle  [int])

AS INSERT INTO [cn3a060_db].[cn3a060].[GroupPerson]   ( [LoginName],   [LoginPwd],   [Question],   [Answer],   [FullName],   [Sex],   [Code],   [Tel],   [Email],   [Oicq1],   [Oicq2],   [Oicq3],   [Oicq4],   [Province],   [City],   [Address],   [Money_Set],   [Money_Person],   [Money_Code],   [GroupName],   [GroupPersonNum],   [GroupGame],   [GroupStyle])   VALUES  ( @LoginName,   @LoginPwd,   @Question,   @Answer,   @FullName,   @Sex,   @Code,   @Tel,   @Email,   @Oicq1,   @Oicq2,   @Oicq3,   @Oicq4,   @Province,   @City,   @Address,   @Money_Set,   @Money_Person,   @Money_Code,   @GroupName,   @GroupPersonNum,   @GroupGame,   @GroupStyle) GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO

setuser N'cn3a060' GO

CREATE PROCEDURE [update_GroupPerson]  (@AutoId  [int],                @Question       [varchar](100),                @Answer         [varchar](100),   @FullName  [varchar](50),   @Sex  [varchar](20),   @Code  [varchar](20),   @Tel  [varchar](50),   @Email  [varchar](100),   @Oicq1  [varchar](20),   @Oicq2  [varchar](20),   @Oicq3  [varchar](20),   @Oicq4  [varchar](20),   @Province  [int],   @City  [int],   @Address  [varchar](200),   @Money_Set  [varchar](100),   @Money_Person  [varchar](200),   @Money_Code  [varchar](25),               @GroupName        [varchar](100),   @GroupPersonNum  [varchar](20),   @GroupGame  [varchar](100),   @GroupStyle  [int])

AS UPDATE [cn3a060_db].[cn3a060].[GroupPerson]

SET           [Question]=@Question,          [Answer]=@Answer,  [FullName]  = @FullName,   [Sex]  = @Sex,   [Code]  = @Code,   [Tel]  = @Tel,   [Email]  = @Email,   [Oicq1]  = @Oicq1,   [Oicq2]  = @Oicq2,   [Oicq3]  = @Oicq3,   [Oicq4]  = @Oicq4,   [Province]  = @Province,   [City]  = @City,   [Address]  = @Address,   [Money_Set]  = @Money_Set,   [Money_Person]  = @Money_Person,   [Money_Code]  = @Money_Code,               [GroupName] =@GroupName,   [GroupPersonNum]  = @GroupPersonNum,   [GroupGame]  = @GroupGame,   [GroupStyle]  = @GroupStyle

WHERE  ( [AutoId]  = @AutoId) GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO

setuser N'cn3a060' GO

CREATE PROCEDURE [update_GroupPerson_Admin]  (@AutoId  [int],   @GroupJianjie  [nvarchar](3000),   @GroupGongGao  [nvarchar](1000),   @GroupPowerLevel  [nvarchar](4000))

AS UPDATE [cn3a060_db].[cn3a060].[GroupPerson]

SET    [GroupJianjie]  = @GroupJianjie,   [GroupGongGao]  = @GroupGongGao,   [GroupPowerLevel]  = @GroupPowerLevel

WHERE  ( [AutoId]  = @AutoId) GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO

setuser N'cn3a060' GO

CREATE PROCEDURE [update_GroupPerson_Show]  (@AutoId  [int],   @GroupJianjie  [ntext],   @GroupGongGao  [ntext],   @GroupPowerLevel  [ntext]               )

AS UPDATE [cn3a060_db].[cn3a060].[GroupPerson]

SET    [GroupJianjie]  = @GroupJianjie,   [GroupGongGao]  = @GroupGongGao,   [GroupPowerLevel]  = @GroupPowerLevel ,               [OneShow] =2

WHERE  ( [AutoId]  = @AutoId) GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO

setuser N'cn3a060' GO

--创建触发器删除时，删除对应的全部字段 CREATE TRIGGER Delete_Group ON cn3a060.GroupPerson FOR  DELETE AS declare @AutoId int select @AutoId = AutoId from deleted delete from Group_TextTemp where GroupId = @AutoId       --删除临时保存内容表 delete from Group_Ad where GroupId=@AutoId delete from Group_Img where GroupId=@AutoId delete from Group_BBS where GroupId=@AutoId delete from GuaranteeOrder where GroupId=@AutoId

GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO

setuser N'cn3a060' GO

CREATE TRIGGER InsertGroup_TextTemp ON cn3a060.GroupPerson FOR INSERT AS declare @AutoId int select @AutoId=AutoId  from Inserted Insert into Group_TextTemp (GroupId) Values (@AutoId)

GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO

setuser N'cn3a060' GO

create trigger update_Group_Ad on [Group_Ad] for update as if update(Show) begin declare @Show  int select @Show=Show from inserted if @Show=2 begin declare @AutoId int select @AutoId=AutoId from inserted Update Group_Ad Set AddTime=dateadd(day,Days,getdate()) Where AutoId=@AutoId end end

GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO

setuser N'cn3a060' GO

--创建触发器删除时，删除对应的全部数据 CREATE TRIGGER Delete_GuaranteeOrder ON cn3a060.GuaranteeOrder FOR  DELETE AS declare @OrderNum varchar select @OrderNum = OrderNum from deleted delete from OperateOrder where OrderNum = @OrderNum       --删除操作记录 delete from MeGroupMoney where OrderNum=@OrderNum      --删除此订单与工作室的结算

GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO

setuser N'cn3a060' GO

--添加游戏时触发器 （自动添加一个代练任务 名称：等级）(自动添加一个服务器 名称：全服) (自动添加一个游戏区 名称:全区 ) CREATE TRIGGER Game_Duty_Area_Server ON cn3a060.Set_Games FOR INSERT AS declare @Game_Id int select @Game_Id=Game_Id  from Inserted Insert into PL_Duty(Game_Id,Duty_Name) values (@Game_Id,'等级') Insert into Set_Game_Server(Game_Id,Area_Id,Server_Name)values(@Game_Id,'0','全服') Insert into Set_Game_Area(Game_Id,Area_Name)values(@Game_Id,'全区')

GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO

setuser N'cn3a060' GO

--创建触发器当删用户时，自动删除相关表信息{同城交易，招聘，求职} CREATE TRIGGER Delete_UserInfo ON [UserInfo] FOR  DELETE AS declare @Email varchar(100) select @Email = Email from deleted delete from GamePro_BuySell where Email = @Email delete from Game_Job  where Email=@Email delete from Game_Work where Email=@Email

GO setuser GO

SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO

 

mygoda
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
3D素材沙发-大家都看看啊可能阿奎那啊设计变体对她说
07-26
3D素材沙发-大家都看看啊可能阿奎那啊设计变体对她说
高中历史第一单元专制理论与民主思想的冲突一西方专制主义理论阿奎那与神学发展素材新人教版选修2
08-05
在学习这个知识点时，学生们应该理解阿奎那理论的核心概念，包括权力的神授观念、教皇与国王的角色定位，以及这对中世纪欧洲社会结构的影响。同时，也要关注这一理论如何与民主思想产生冲突，因为民主思想强调人民的...
mysql insert锁机制【转】
weixin_33739627的博客
05-19 1789
最近再找一些MySQL锁表原因，整理出来一部分sql语句会锁表的，方便查阅，整理的不是很全，都是工作中碰到的，会持续更新 笔者能力有限，如果有不正确的，或者不到位的地方，还请大家指出来，方便你我，方便大家。 此测试环境 Mysql 5.5 基于innodb 引擎   [sql] view plain copy   insert into  table1 value...
创建SQL作业错误的解决方法（不能将值 NULL 插入列 'owner_sid'，表 'msdb.dbo.sysjobs'；列不允许有空值。）
热门推荐
holyrong的专栏
11-25 1万+
在用SQL语句创建SQL Server作业时有时出现如下错误：消息 515，级别 16，状态 2，过程 sp_add_job，第 137 行不能将值 NULL 插入列 owner_sid，表 msdb.dbo.sysjobs；列不允许有空值。INSERT 失败。语句已终止。 这可能与为作业创建的数据库登录ID有关，这个登录ID需要是数据库的所有者（我的是sa），
一图看懂西方哲学全脉络
图形跟班
09-13 1万+
文章转自：http://blog.sina.com.cn/s/blog_492faa8f0102edh1.html 版权归原作者！ 以上，古希腊罗马哲学包括自然哲学、形而上学和伦理哲学三个阶段，为西方哲学的理性思辨和形而上学打下了传统根基。 它提出了逻辑、存在、实体等成为西方哲学的经典命题，而柏拉图和亚里士多德关于共相性质的争论开启了中世纪基督教哲学关于唯名论和实在论的争论。 以上，西罗
MYSQL坎坷安装之路
zdz的博客
04-03 86
我最终成功启动MySQL是参考这个https://www.cnblogs.com/rm6700/p/5924843.html 一、官网下载，推荐使用360极速浏览器，因为它自带翻译，可以阿奎那东因为网站。 下载注意，2020-04-03现在没有win10 64位安装版，只有win10 32位安装版，win10 64位只有解压版，所以务必下载对应版本的安装包（安装版就用安装版，解压版就用解压版） 二...
儒家学派有哪些代表人物？
程序大视界
07-16 1568
中国古代儒家圣人：孔子、王阳明、曾国藩
请不要封我的号0.0
tiancongcong的专栏
11-05 169
就看哈功耗和危机感啊我还不敢接啊哦规划jaw计划啊很快就安慰h'g'ka'b'n'w
梁彪：西方多值逻辑发展的四个阶段
blog of eulota
09-05 2278
<br />http://philosophy.sysu.edu.cn/papers/ShowArticle.asp?ArticleID=1728<br /> <br />    多值逻辑是正在发展着的现代逻辑的一个领域，追根溯源，多值逻辑产生和发展的线索可以追溯到古希腊时期亚里士多德等人对“未来偶然”问题以及对命题的模态问题的讨论。作为现代形式的多值逻辑系统是20世纪20年代提出来的，从那时起，多值逻辑成为现代逻辑的分支。纵观西方多值逻辑发展的过程，大致可以分为四个阶段。<br />一、多值逻辑的孕育阶段
西方哲学史的主要发展阶段
weixin_30906671的博客
11-29 1340
1．古希腊哲学 西方哲学史开始产生于古希腊奴隶社会。古希腊哲学是在东方、埃及巴比伦文化的影响下发展起来的，它从神话传说中，首先注意物理世界的起源与本性，集中于对宇宙本原的研究。最早的有米利都学派，以后有毕泰戈拉学派、赫拉克利特、爱利亚学派和原子论者，一般称之为自然哲学家或宇宙论者。 最初的自然哲学家和以前的宗教家不同，他们很重视自然科学的研究，但他们毕竟处于哲学思想发展的...
中世纪的经济发展及其在思想上的反映.docx
11-26
然而，随着时间的推移，思想家如托马斯·阿奎那开始反映出明显的等级特征，他将“公正价格”解释为能反映卖主等级地位的价格，强调效用相等和主观价值，这反映了商品货币交换的发展对经济思想的影响。 阿奎那对商业...
高中历史第一单元专制理论与民主思想的冲突一西方专制主义理论阿奎那与神学发展素材新人教版选修2.doc
12-02
高中历史第一单元专制理论与民主思想的冲突一西方专制主义理论阿奎那与神学发展素材新人教版选修2.doc
2019_2020学年高中历史第一单元从“朕即国家”到“主权在民”单元过关检测岳麓版选修2
09-09
8. **阿奎那与理性**：阿奎那引入理性来证明神学，他的目的是使神学更具逻辑性和清晰度，而非摧毁理性或神学。 9. **“君权神授”与“君权至上”**：詹姆士一世与马基雅弗利在君权来源上的分歧，前者主张君权神授，...
ubuntu20.04 安装微信
AI浩
09-06 1789
1、 安装必要的工具及deepin-wine依赖 sudo apt install wget g++ git 2、安装deepin-wine git clone "https://gitee.com/wszqkzqk/deepin-wine-for-ubuntu.git" cd deepin-wine-for-ubuntu #切换到下载目录 sudo ./install.sh #执行安装 3、安装微信 下载地址： https://gi
PostgreSQL 中如何解决因大量并发删除和插入操作导致的索引抖动？
技术笔记
07-17 845
索引抖动是 PostgreSQL 中一个常见的问题，它会对数据库的性能产生严重的影响。通过采用批量操作、分区表、索引优化和调整数据库参数等方法，我们可以有效地解决索引抖动问题，提高数据库的性能和稳定性。在实际应用中，我们应该根据具体情况选择合适的解决方案，并不断地进行优化和调整，以满足业务的需求。解决索引抖动问题就像是一场战斗，我们需要根据敌人（问题）的特点和弱点，选择合适的武器（解决方案），并灵活运用战术（优化方法），才能取得最终的胜利。
接口开发：Orcal数据库的批量新增sql
qq_65032048的博客
07-17 780
场景：在日常的CURD中一定会用到批量新增。在我们的项目中，使用的数据库是Orcal，由于之前基本都是使用Mysql的，使用的sql语句也基本都是用mysql的。但是在这次的接口编写时用mysql的批量新增出了问题，刚开始我还以为是写的动态sql有问题，在后续的问题修改也主要是对动态sql修改，因此也浪费了大量的时间，在后续把sql搬到数据库运行一下后才发现是sql的问题，同时也了解到了mysql和orcal 也是有很多地方是不同的。
SQL执行流程、SQL执行计划、SQL优化
最新发布
风中的默默
07-19 296
返回两个表中的匹配行。返回左表中的所有记录以及右表中的匹配记录。返回右表中的所有记录以及左表中的匹配记录。返回左侧或右侧表中有匹配的所有记录。
创新思维理论与方法：练习及解析
这强调了思维在人类文明和认知发展中的核心地位，它不仅是我们理解世界和解决问题的基础，也是我们创造和创新的源泉。 2. 思维的逻辑性是指其按照一定的形式、方法和规则进行，体现了合理性。逻辑性是保证思维有效...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值