SQLServer中exists和except用法介绍（sql2008分离数据库步骤）新鲜出炉

🌐 经济型：买域名、轻量云服务器、用途：游戏网站等《腾讯云》特点：特价机便宜适合初学者用点我优惠购买

🚀 拓展型：买域名、轻量云服务器、用途：游戏网站等《阿里云》特点：中档服务器便宜域名备案事多点我优惠购买

🛡️ 稳定型：买域名、轻量云服务器、用途：游戏网站等《西部数码》特点：比上两家略贵但是稳定性超好事也少点我优惠购买

– —————————-
— Table structure for family_grade
— —————————-
DROP TABLE [mazeytop].[family_grade]
GO
CREATE TABLE [mazeytop].[family_grade] (
[id] int NOT NULL ,
[name] varchar(20) NULL ,
[grade] int NULL
)

— —————————-
— Records of family_grade
— —————————-
INSERT INTO [mazeytop].[family_grade] ([id], [name], [grade]) VALUES (N’1′, N’mazey’, N’70’)
GO
GO
INSERT INTO [mazeytop].[family_grade] ([id], [name], [grade]) VALUES (N’2′, N’cherrie’, N’93’)
GO
GO

— —————————-
— Table structure for family_member
— —————————-
DROP TABLE [mazeytop].[family_member]
GO
CREATE TABLE [mazeytop].[family_member] (
[id] int NOT NULL ,
[name] varchar(20) NULL ,
[sex] varchar(20) NULL ,
[age] int NULL ,
[group_level] int NULL
)

— —————————-
— Records of family_member
— —————————-
INSERT INTO [mazeytop].[family_member] ([id], [name], [sex], [age], [group_level]) VALUES (N’1′, N’mazey’, N’male’, N’23’, N’1′)
GO
GO
INSERT INTO [mazeytop].[family_member] ([id], [name], [sex], [age], [group_level]) VALUES (N’2′, N’cherrie’, N’female’, N’22’, N’2′)
GO
GO
INSERT INTO [mazeytop].[family_member] ([id], [name], [sex], [age], [group_level]) VALUES (N’3′, N’rabbit’, N’female’, N’15’, N’3′)
GO
GO
INSERT INTO [mazeytop].[family_member] ([id], [name], [sex], [age], [group_level]) VALUES (N’4′, N’rabbit’, N’female’, N’15’, N’3′)
GO
GO

— —————————-
— Table structure for family_part
— —————————-
DROP TABLE [mazeytop].[family_part]
GO
CREATE TABLE [mazeytop].[family_part] (
[id] int NOT NULL ,
[group] int NULL ,
[group_name] varchar(20) NULL
)

— —————————-
— Records of family_part
— —————————-
INSERT INTO [mazeytop].[family_part] ([id], [group], [group_name]) VALUES (N’1′, N’1′, N’父亲’)
GO
GO
INSERT INTO [mazeytop].[family_part] ([id], [group], [group_name]) VALUES (N’2′, N’2′, N’母亲’)
GO
GO
INSERT INTO [mazeytop].[family_part] ([id], [group], [group_name]) VALUES (N’3′, N’3′, N’女儿’)
GO
GO

— —————————-
— Indexes structure for table family_grade
— —————————-

— —————————-
— Primary Key structure for table family_grade
— —————————-
ALTER TABLE [mazeytop].[family_grade] ADD PRIMARY KEY ([id])
GO

— —————————-
— Indexes structure for table family_member
— —————————-

— —————————-
— Primary Key structure for table family_member
— —————————-
ALTER TABLE [mazeytop].[family_member] ADD PRIMARY KEY ([id])
GO

— —————————-
— Indexes structure for table family_part
— —————————-

— —————————-
— Primary Key structure for table family_part
— —————————-
ALTER TABLE [mazeytop].[family_part] ADD PRIMARY KEY ([id])
GO