appendixc_memberdetailstable_data.txt

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

INSERT INTO MemberDetails
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  1,
  'Katie', 
  'Smith', 
  '1977-01-09', 
  'Main Road',
  'Townsville',
  'Stateside',
  '123456',
  '[e-mail]',
  '2004-02-23'
 );

INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  2,
  'Bob', 
  'Robson', 
  '1987-01-09', 
  'Little Street',
  'Big City',
  'Small State',
  '34565',
  '[e-mail]',
  '2004-03-13'
 );

INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  3,
  'Sandra', 
  'Jakes', 
  '1957-05-15', 
  'The Avenue',
  'Windy Village',
  'Golden State',
  '65423',
  'sandra@her_mail.com',
  '2004-04-13'
 );

INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  4,
  'Steve', 
  'Gee', 
  '1967-10-05', 
  'The Road',
  'Windy Village',
  'Golden State',
  '65424',
  '[e-mail]',
  '2004-02-22'
 );

INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  5,
  'John', 
  'Jones', 
  '1952-10-05', 
  'New Lane',
  'Big Apple City',
  'New State',
  '88776',
  '[e-mail]',
  '2005-01-02'
 );

INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  6,
  'Jenny', 
  'Jones', 
  '1953-08-25', 
  'New Lane',
  'Big Apple City',
  'New State',
  '88776',
  '[e-mail]',
  '2005-01-02'
 );