學習筆記

USE [sqltest]
GO
/****** Object:  Table [dbo].[Table_1]    Script Date: 2016/11/20 下午 05:52:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Table_1](
    [name] [varchar](50) NOT NULL,
    [age] [int] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Table_2]    Script Date: 2016/11/20 下午 05:52:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Table_2](
    [name] [varchar](50) NOT NULL,
    [sex] [bit] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Table_3]    Script Date: 2016/11/20 下午 05:52:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Table_3](
    [name] [varchar](50) NOT NULL,
    [birthday] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'王大明', 20)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'王小明', 25)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'陳一美', 28)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'陳二美', 30)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'陳大美', 31)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'陳小美', 32)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'胖O虎', 15)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'大O雄', 14)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'靜O香', 14)
INSERT [dbo].[Table_1] ([name], [age]) VALUES (N'多拉V夢', 100)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'王大明', 0)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'王小明', 0)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'陳一美', 1)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'陳二美', 1)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'陳大美', 1)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'陳小美', 1)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'胖O虎', 0)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'大O雄', 0)
INSERT [dbo].[Table_2] ([name], [sex]) VALUES (N'靜O香', 1)
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'王大明', CAST(N'1990-03-09 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'王小明', CAST(N'1999-10-06 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'陳一美', CAST(N'1994-07-08 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'陳二美', CAST(N'1996-02-03 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'陳大美', CAST(N'1999-04-04 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'陳小美', CAST(N'2002-04-29 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'胖O虎', CAST(N'1964-06-15 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'大O雄', CAST(N'1964-08-07 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'靜O香', CAST(N'1964-05-02 00:00:00.000' AS DateTime))
INSERT [dbo].[Table_3] ([name], [birthday]) VALUES (N'多拉V夢', CAST(N'2112-09-03 00:00:00.000' AS DateTime))