appendixc_favcategorytable_data.txt

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

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  1,
  3
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  1,
  5
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  1,
  2
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  1,
  3
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  2,
  1
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  2,
  3
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  3,
  3
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  4,
  6
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  4,
  1
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  5,
  2
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  5,
  3
 );

INSERT INTO FavCategory 
(
  CategoryId,
  MemberId
)
VALUES
 ( 
  5,
  4
 );