appendixc_oracle_attendancetable_data.txt

来自「SQL Server入门经典源码」· 文本 代码 · 共 180 行

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  1
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'N',
  2
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  3
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'N',
  4
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  5
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  2,
  '1 Jan 2004',
  'Y',
  6
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'Y',
  1
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'N',
  2
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'Y',
  3
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'Y',
  4
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',  
  'N',
  5
 );

INSERT INTO Attendance 
(
  LocationId,
  MeetingDate,
  MemberAttended,
  MemberId
)
VALUES
 ( 
  1,
  '1 Mar 2004',
  'N',
  6
 );