insert-data.sql

来自「ASP.NET Web Forms Techniques」· SQL 代码 · 共 390 行 · 第 1/3 页

INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 5)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 7)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 9)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 10)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 12)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 14)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 16)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 17)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 19)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 22)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 25)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 28)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 29)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 35)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 36)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 37)
GO
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 38)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 1)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 2)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 6)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 8)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 9)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 10)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 13)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 14)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 16)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 17)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 18)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 23)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 24)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 25)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 27)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 31)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 33)
GO
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 34)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 35)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 36)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (2, 38)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 2)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 3)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 4)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 5)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 7)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 10)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 12)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 14)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 15)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 16)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 19)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 20)
GO
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 25)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 28)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 29)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 31)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 35)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 36)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 37)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (3, 38)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 1)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 2)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 3)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 4)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 5)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 8)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 13)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 15)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 16)
GO
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 19)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 22)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 28)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 29)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 31)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 36)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 37)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (4, 38)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 2)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 4)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 5)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 9)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 17)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 25)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 35)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (5, 38)
GO

/****** tblCarExtras ******/
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 1)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 2)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 3)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 4)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 5)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 6)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 7)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 9)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 10)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (1, 12)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (2, 1)
GO
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (2, 4)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (2, 5)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (2, 6)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (2, 7)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (2, 11)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 1)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 2)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 3)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 4)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 5)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 9)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 10)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 11)
GO
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (3, 12)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (4, 1)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (4, 3)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (4, 5)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (4, 9)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (4, 10)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (4, 11)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (4, 12)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (5, 1)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (5, 3)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (5, 7)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (5, 8)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (5, 9)
INSERT INTO tblCarExtras (CarID, ExtraID) VALUES (5, 12)