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
)

GO

— —————————-
— 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
)

GO

— —————————-
— 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
)

GO

— —————————-
— 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