insert-data.sql

ASP.NET Web Forms Techniques

DELETE FROM tblCarColors
GO
DELETE FROM tblCarEngines
GO
DELETE FROM tblCarExtras
GO
DELETE FROM tblCar
GO
DELETE FROM tblColor
GO
DELETE FROM tblEngine
GO
DELETE FROM tblOptionExtra
GO
DELETE FROM tblNews
GO
DELETE FROM tblUsers
GO
DELETE FROM tblQuoteOrder
GO
DELETE FROM tblQuoteOrderExtras
GO
DELETE FROM tblMailingList
GO

/****** tblCar ******/
SET IDENTITY_INSERT tblCar ON
GO
INSERT INTO tblCar (CarID, Model, Precis) VALUES (1, 'Wrampant', 'Our original and still the most popular sports car in our range. The Wrampant provides a unique combination of performance and comfort that will suit almost any driver. Happy around town, and yet with extra horses under the bonnet so that you can take advantage of the open road. With its 2 x 2 seat combination, and spacious luggage carrying features, it makes an ideal car for both short and long journeys.')
INSERT INTO tblCar (CarID, Model, Precis) VALUES (2, 'Wregal', 'There are three words that describe the Xrox Wregal: luxury, luxury and luxury. Soft leather interior, perfect soundproofing, and all the extras you could want inside, this is the car that makes you feel like the chairman of the corporation. But we still build in great performance and amazing handling and road-holding capabilities, so your chauffeur can have fun as well.')
INSERT INTO tblCar (CarID, Model, Precis) VALUES (3, 'Wresponse', 'Sports cars are about responsiveness, and the best car is the one that not only puts the power down onto the road - but that responds to your control. The Wresponse does that, in a way that you won''t be able to imagine till you try it. Smooth yet amazingly powerful, and easy to drive so you can use it round town as well as for those exhilarating cross-country sprints.')
INSERT INTO tblCar (CarID, Model, Precis) VALUES (4, 'Wroadster', 'Fame and fortune come to those who strive for it, and with the Wroadster, we''ve already done the striving for you. A confirmed winner in its class, this road-legal racer will both scare you to death and yet satisfy the most concerting driver. Raw power delivered to the wheels without any compromise, this car is horsepower in a pretty box - without the fancy packaging.')
INSERT INTO tblCar (CarID, Model, Precis) VALUES (5, 'Wranger', 'Whether you''ve got a big job to do, a lot of equipment to carry, or you just like to give the appearance of being a big-city farmer, the Wranger is the ideal truck for you. Hugely powerful, massively strong, and unbelievably reliable, it will easily handle everything you can throw at it.')
GO
SET IDENTITY_INSERT tblCar OFF
GO

/****** tblColor ******/
SET IDENTITY_INSERT tblColor ON
GO
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (1, 'Silver', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (2, 'Black', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (3, 'Pink', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (4, 'Yellow', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (5, 'Red', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (6, 'AliceBlue', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (7, 'Aqua', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (8, 'Azure', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (9, 'Beige', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (10, 'CadetBlue', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (12, 'DodgerBlue', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (13, 'Firebrick', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (14, 'ForestGreen', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (15, 'Fuchsia', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (16, 'Gold', -1)
GO
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (17, 'Gray', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (18, 'Honeydew', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (19, 'HotPink', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (20, 'Khaki', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (22, 'LimeGreen', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (23, 'Linen', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (24, 'Maroon', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (25, 'MidnightBlue', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (26, 'Moccasin', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (27, 'Navy', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (28, 'Orange', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (29, 'Plum', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (31, 'PowderBlue', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (33, 'RoyalBlue', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (34, 'SeaGreen', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (35, 'SteelBlue', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (36, 'Thistle', -1)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (37, 'Tomato', 0)
INSERT INTO tblColor (ColorID, Color, IsMetallic) VALUES (38, 'White', 0)
GO
SET IDENTITY_INSERT tblColor OFF
GO

/****** tblOptionExtra ******/
SET IDENTITY_INSERT tblOptionExtra ON
GO
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (1, 'Satellite Navigation', 649)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (2, 'Leather Trim', 899)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (3, 'Air Conditioning', 1755)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (4, 'Heated Seats', 325)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (5, '6 Disc CD Player', 925)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (6, 'Child Seat', 79)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (7, 'Towbar', 279)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (8, 'Power Winch', 437)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (9, 'Electric Windows', 399)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (10, 'Electric Sunroof', 250)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (11, 'Gold Alloy Wheels', 925)
INSERT INTO tblOptionExtra (ExtraID, ExtraText, ExtraPrice) VALUES (12, 'Fog/Driving Lamps', 138)
GO
SET IDENTITY_INSERT tblOptionExtra OFF
GO

/****** tblEngine ******/
SET IDENTITY_INSERT tblEngine ON
GO
INSERT INTO tblEngine (EngineID, EngineName, Cylinders, Turbo, Gears, CubicCapacity, FuelType, MaxRPM, BHP, AutoTrans) VALUES (1, '1.6 16V', 4, 0, 5, 1599, 'Gas/Petrol', 6800, 94, 0)
INSERT INTO tblEngine (EngineID, EngineName, Cylinders, Turbo, Gears, CubicCapacity, FuelType, MaxRPM, BHP, AutoTrans) VALUES (2, '2.0i 16V', 4, 0, 5, 1998, 'Gas/Petrol', 7200, 103, -1)
INSERT INTO tblEngine (EngineID, EngineName, Cylinders, Turbo, Gears, CubicCapacity, FuelType, MaxRPM, BHP, AutoTrans) VALUES (3, '2.8 V6', 6, 0, 5, 2795, 'Gas/Petrol', 8600, 164, -1)
INSERT INTO tblEngine (EngineID, EngineName, Cylinders, Turbo, Gears, CubicCapacity, FuelType, MaxRPM, BHP, AutoTrans) VALUES (4, '2.5 D V6', 6, 0, 4, 2498, 'Diesel', 5400, 87, 0)
INSERT INTO tblEngine (EngineID, EngineName, Cylinders, Turbo, Gears, CubicCapacity, FuelType, MaxRPM, BHP, AutoTrans) VALUES (5, '3.2 D V6', 6, -1, 5, 3197, 'Diesel', 5700, 96, -1)
INSERT INTO tblEngine (EngineID, EngineName, Cylinders, Turbo, Gears, CubicCapacity, FuelType, MaxRPM, BHP, AutoTrans) VALUES (6, '4.8 V8', 8, -1, 5, 4793, 'Gas/Petrol', 9200, 235, 0)
INSERT INTO tblEngine (EngineID, EngineName, Cylinders, Turbo, Gears, CubicCapacity, FuelType, MaxRPM, BHP, AutoTrans) VALUES (7, '6.2 V12', 12, -1, 6, 6180, 'Gas/Petrol', 11300, 340, 0)
GO
SET IDENTITY_INSERT tblEngine OFF
GO

/****** tblCarEngines ******/
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (1, 103, 18, 1, NULL, 22, 5.7, 16, 7.1, 9.2, 61, 51, 11.3, 44, 43, 12.9, 28, 34, 15.2, 31, 22995, 17.8, 27, 19.2, 82)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (1, 112, 16, 2, NULL, 21, 4.4, 14, 5.9, 7.8, 65, 48, 9.6, 47, 39, 11.4, 32, 30, 13.1, 28, 24795, 14.6, 25, 16.5, 90)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (2, 98, 11, 3, NULL, 15, 3.6, NULL, 6.2, 8.2, 59, 39, 10.4, 40, 31, 12.2, 26, 24, 14.5, 22, 43500, 16.7, 19, NULL, 73)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (2, 107, 13, 5, NULL, 17, 6.8, 10, 8.2, 11.6, 62, 43, 14.2, 43, 34, 16.2, 27, 26, 18.7, 23, 44850, 20.5, 21, 23.8, 77)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (3, 119, 11, 3, NULL, 14, 2.9, 9, 4.3, 5.9, 66, 39, 7.5, 48, 32, 9, 33, 22, 10.4, 20, 37990, 11.6, 17, 13.7, 92)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (3, 137, 7, 6, NULL, 9, 1.9, 6, 3.5, 4.1, 77, 28, 4.9, 52, 21, 5.9, 39, 16, 7.2, 14, 42225, 9.1, 12, 11.3, 101)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (4, 153, 3, 7, 193, 5, 1.2, 2, 2, 2.9, 95, 24, 3.4, 62, 18, 3.8, 47, 11, 4.6, 10, 89750, 5.6, 8, 6.8, 128)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (5, NULL, 15, 4, NULL, 18, 7.4, NULL, 10.8, 13.3, 73, 47, 15.8, 51, 36, 18.7, 28, 27, 23.3, 25, 27950, 27.9, 22, NULL, 97)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (5, 106, 10, 5, NULL, 13, 6.1, 9, 8.7, 10.5, 62, 36, 13.2, 45, 30, 16.5, 24, 22, 19.8, 20, 29495, 23.2, 17, 27.6, 84)
INSERT INTO tblCarEngines (CarID, Speed5th, Fuel90, EngineID, Speed6th, Fuel80, Perf30, Fuel100, Perf40, Perf50, Speed3rd, Fuel30, Perf60, Speed2nd, Fuel40, Perf70, Speed1st, Fuel50, Perf80, Fuel60, CarEnginePrice, Perf90, Fuel70, Perf100, Speed4th) VALUES (5, 118, 9, 6, NULL, 12, 3.3, 7, 5.4, 6.8, 65, 33, 9.7, 48, 25, 11.6, 26, 18, 13.5, 17, 33275, 15.2, 15, 17.1, 91)
GO

/****** tblCarColors ******/
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 1)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 2)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 3)
INSERT INTO tblCarColors (CarID, ColorID) VALUES (1, 4)