chapter2_exercisesolutions.txt

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

INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  7,
  'John', 
  'Jackson', 
  '1974-05-27', 
  'Long Lane',
  'Orange Town',
  'New State',
  '88992',
  '[e-mail]',
  '2005-11-21'
 );


INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  8,
  'Jack', 
  'Johnson', 
  '1945-06-09', 
  'Main Street',
  'Big City',
  'Mega State',
  '34566',
  '[e-mail]',
  '2005-06-02'
 );


INSERT INTO MemberDetails 
(
  MemberId,
  FirstName,
  LastName,
  DateOfBirth,
  Street,
  City,
  State,
  ZipCode,
  Email,
  DateOfJoining
)
VALUES
 ( 
  9,
  'Seymour', 
  'Botts', 
  '1956-10-21', 
  'Long Lane',
  'Windy Village',
  'Golden State',
  '65422',
  '[e-mail]',
  '2005-07-17'
 );

DELETE FROM Attendance WHERE MemberId = 2;

DELETE FROM FavCategory WHERE MemberId = 2;

DELETE FROM MemberDetails WHERE MemberId = 2;

UPDATE MemberDetails SET City = 'Big City' 
 WHERE Street = 'Long Lane' AND City = 'Orange Town';