Introduction

Most computer applications uses some types of lists. One way to create and store a formal list for an application is in term of a computer database. This is done using a special application, and there are many of them, such as desktop databases like Microsoft Access. Some projects require a large database that can hold millions of values. One of those applications is Microsoft SQL Server. In this exercise, we will have a small introduction to Microsoft SQL Server. We will create a simple database. We will add a simple table to it, then we will add a few records to that table.

This exercise assumes that you have Microsoft SQL Server installed on your computer (you probably know that Microsoft SQL Server is free; you can download it freely on the Microsoft website; then you should also download and install SQL Server Management Studio).

Practical LearningPractical Learning: Introducing the Project

  1. Start SQL Server Management Studio
  2. Log in
  3. In the Object Explorer, right-click the top node and click New Query

A Database

For this project, we need a database. We will create a small one using the simplest possible code.

Practical LearningPractical Learning: Creating a Database

  1. In the empty Query Editor, type the following code: 
    USE master;
GO
IF DB_ID (N'CollegeParkAutoParts1') IS NOT NULL
	DROP DATABASE CollegeParkAutoParts1;
GO
CREATE DATABASE CollegeParkAutoParts1;
GO
USE CollegeParkAutoParts1;
GO
  2. To execute and create the database, click the Execute button
  3. Delete everything in the Query Editor

A Table

The most fundamental part of a database is a table. A table is an arrangement of some of the values that a database holds. For our introduction, we will create a simple table.

A table organizes its values in categories. Each category is called a column or a field. Some details are required on a column and some others are optional. As one of the requirements, a column must have a name. Although there are some rules and suggestions for names, you should use simple names that have only regular (English) letters without a space in-between. Another requirement of a column is the type of values that it will hold. Among the options of a field, you can specify whether it can be empty or it must hold a value.

Practical LearningPractical Learning: Creating a Table

  1. In the Query Editor, type the following code: 
    USE CollegeParkAutoParts1;
GO
CREATE TABLE AutoParts
(
	AutoPartsId INT IDENTITY(1, 1),
	PartNumber  INT          NOT NULL,
	CarYear     INT          NOT NULL, 
	Make        NVARCHAR(50),
	Model       NVARCHAR(150),
	Category    NVARCHAR(150),
	PartName    NVARCHAR(255) NOT NULL,
	UnitPrice   MONEY         NOT NULL,
	CONSTRAINT PK_AutoParts PRIMARY KEY (AutoPartsId)
);
GO
  2. To execute and create the table, click the Execute button
  3. Delete everything in the Query Editor

A Record

A record is a list of values of a table where the categories of values, named columns, are represented. Normally, each column is represented with its own value, but when a column doesn't have a value, its section is left empty. The values of a table display as a row; that's why the group or row is called a record.

To make a table hold some values, those values must be added. There are various ways to add a record of values to a table. We will see just one way to do that, and we will repeat the technique so we can add as many records as we want.

Practical LearningPractical Learning: Adding Records to a Table

  1. In the Query Editor, type the following code: 
    INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(393795, 2015, N'Buick', N'Regal', N'Alternators & Generators', N'DB Electrical Alternator', 218.74);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(155975, 2010, N'Buick', N'Lacrosse', N'Hub Assemblies', N'Front/Rear Wheel Hub Bearing Assembly', 94.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(928374, 2018, N'Chevrolet', N'Express 3500', N'Shocks, Struts & Suspension', N'Suspension Kit (Front; with 3 Groove Pitman Arm)', 142.44);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(148040, 2010, N'Chrysler', N'Town & Country 3.8L', N'Alternators & Generators', N'Alternator', 118.37);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(730283, 2020, N'Jeep', N'Wrangler Unlimited Sahara', N'Oil Filters', N'Hydraulic Cylinder Timing Belt Tensioner', 14.15);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(290741, 2015, N'Ford', N'F-150 XL 3.5L V6 Flex Regular Cab 2 Full-Size Doors', N'Shocks, Struts & Suspension', N'Front Strut and Coil Spring Assembly - Set of 2', 245.68);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(693748, 2015, N'Cadillac', N'Escalade Esv', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(740248, 2013, N'Chevrolet', N'Equinox', N'Bearings & Seals', N'Wheel hub bearing Assembly', 99.95);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(137497, 2005, N'Audi', N'A4', N'Fuel System', N'High Pressure Fuel Pump', 96.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(283759, 2012, N'Dodge', N'Charger 3.6L', N'Starters', N'DB Electrical SND0787 Starter', 212.58);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(188374, 2015, N'GMC', N'Yukon XL', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(928479, 2006, N'Honda', N'Accord 2.4L L4', N'Steering Pump', N'Power Steering Pump', 68.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(503502, 2008, N'Jeep', N'Wrangler', N'Alternators', N'Alternator', 114.46);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(130338, 2011, N'Buick', N'Enclave', N'Brake Kits', N'Autospecialty Front and Rear Replacement Brake Kit-OE Brake Rotors & Ceramic Brake Pads', 315.27);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(799428, 2012, N'Cadillac', N'XTS', N'Bearings & Seals', N'Front/Rear Wheel Hub Bearing Assembly 5 Lugs w/ABS', 79.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(648203, 2018, N'Honda', N'CRV', N'Alternator', N'Alternator', 202.47);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(203847, 2014, N'Chevrolet', N'Impala ', N'Hub Assemblies', N'Front/Rear Wheel Hub Bearing Assembly', 94.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(148073, 2011, N'Chrysler', N's200', N'Starters', N'DB Electrical SND0775 Starter', 94.48);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(308113, 2017, N'Buick', N'Enclave', N'Brake Kits', N'Autospecialty Front and Rear Replacement Brake Kit-OE Brake Rotors & Ceramic Brake Pads', 315.27);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(938475, 2010, N'Chrysler', N'Sebring', N'Starters', N'DB Electrical SMT0343 Starter', 82.66);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(502853, 2014, N'GMC', N'Terrain', N'Bearings & Seals', N'Wheel Hub Bearing Assembly', 48.85);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(292804, 2016, N'Chevrolet', N'Tahoe Suburban', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(618274, 2007, N'VW', N'Passat 2.0T, Value Edition, Wolfsburg Edition 2.0L L4 - Gas', N'Electric Fuel Pumps', N'Electric High Pressure Fuel Pump', 108.16);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(494844, 2011, N'Honda', N'Accord', N'Brake System', N'Front Vented Replacement Brake Rotors Kit - Drilled Slotted Brake Rotors & Ceramic Brake Pads', 110.58);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(520384, 2020, N'Jeep', N'Wrangler Unlimited Sahara', N'Drum Brake', N'Rear Dynamic Friction Company True-Arc Brake Shoes', 42.22);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(727394, 2018, N'Toyota', N'Corolla SE 1.8L L4 Gas', N'Alternators', N'DB Electrical 400-40169 Alternator Compatible With/Replacement For 125 Internal Fan Type Decoupler Pulley Type Internal Regulator CW Rotation', 215.84);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(483804, 2011, N'Chrysler', N'Town & Country 3.3L', N'Alternators & Generators', N'', 118.37);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(927944, 2017, N'Chevrolet', N'Equinox', N'Bearings & Seals', N'Wheel Hub Bearing Assembly', 48.85);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(208497, 2009, N'Dodge', N'Grand Caravan', N'Alternators', N'Alternator', 114.46);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(749471, 2019, N'Toyota', N'Prius', N'Shocks, Struts & Suspension', N'2-Piece Suspension Strut and Coil Spring Kit (593024)', 299.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(625826, 2006, N'VW', N'Passat 2.0T', N'Fuel System', N'High Pressure Fuel Pump', 96.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(371829, 2006, N'Acura', N'RSX', N'Steering Pump', N'Power Steering Pump', 68.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(957724, 2016, N'Chrysler', N's200', N'Starters', N'DB Electrical SND0775 Starter', 94.48);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(397930, 2008, N'Buick', N'Enclave', N'Brake Kits', N'Autospecialty Front and Rear Replacement Brake Kit-OE Brake Rotors & Ceramic Brake Pads', 315.27);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(308475, 2018, N'Cadillac', N'Escalade Esv', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(927307, 2014, N'Buick', N'Regal', N'Alternators & Generators', N'DB Electrical Alternator', 218.74);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(495928, 2013, N'Cadillac', N'XTS', N'Hub Assemblies', N'Front/Rear Wheel Hub Bearing Assembly', 94.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(304031, 2017, N'Chevrolet', N'Express 2500', N'Shocks, Struts & Suspension', N'Suspension Kit (Front; with 3 Groove Pitman Arm)', 142.44);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(497249, 2013, N'GMC', N'Sierra 1500', N'Drum Brake', N'ACDelco Gold 17960BF1 Bonded Rear Drum Brake Shoe Set', 58.92);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(973947, 2012, N'Honda', N'Accord', N'Brake Kits', N'R1 Concepts Front Rear Brakes and Rotors Kit |Front Rear Brake Pads| Brake Rotors and Pads| Ceramic Brake Pads and Rotors', 292.84);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(868050, 2010, N'Dodge', N'Avenger', N'Starters', N'DB Electrical SMT0343 Starter', 82.66);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(182694, 2016, N'Chevrolet', N'Impala', N'Bearings & Seals', N'Wheel Hub Bearing Assembly', 48.85);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(209246, 2013, N'Chevrolet', N'Silverado 1500', N'Drum Brake', N'ACDelco Gold 17960BF1 Bonded Rear Drum Brake Shoe Set', 58.92);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(273947, 2008, N'VW', N'Passat 2.0L L4', N'Electric Fuel Pumps', N'High Pressure Fuel Pump', 105.17);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(738047, 2017, N'GMC', N'Acadia Limited', N'Brake Kits', N'Autospecialty Front and Rear Replacement Brake Kit-OE Brake Rotors & Ceramic Brake Pads', 315.27);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(393511, 2014, N'Chrysler', N's200', N'Starters', N'DB Electrical SND0775 Starter', 94.48);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(297149, 2020, N'Jeep', N'Wrangler', N'Air Filters', N'ACDelco Gold A3408C Air Filter', 22.83);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(748073, 2009, N'Volkswagen', N'Routan', N'Alternators', N'Alternator', 114.46);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(927397, 2016, N'Chevrolet', N'Impala', N'Bearings & Seals', N'Front/Rear Wheel Hub Bearing Assembly 5 Lugs w/ABS', 79.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(830074, 2011, N'Buick', N'Enclave', N'Brake Kits', N'Autospecialty Front and Rear Replacement Brake Kit-OE Brake Rotors & Ceramic Brake Pads', 315.27);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(392972, 2020, N'Toyota', N'Prius AWD-e', N'Shocks, Struts & Suspension', N'2-Piece Suspension Strut and Coil Spring Kit (593024)', 299.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(928037, 2017, N'Buick', N'Regal', N'Alternators & Generators', N'DB Electrical Alternator', 218.74);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(304859, 2012, N'Audi', N'TT Quattro Premium Plus, Prestige, S 2.0L L4 - Gas', N'Electric Fuel Pumps', N'Electric High Pressure Fuel Pump', 108.16);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(502481, 2016, N'Chevrolet', N'Equinox', N'Bearings & Seals', N'Wheel hub bearing Assembly', 99.95);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(539418, 2018, N'Chevrolet', N'Tahoe Suburban', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(593804, 2019, N'Honda', N'Accord LX 1.5L L4 Gas', N'Alternator', N'Alternator', 202.47);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(293748, 2014, N'Toyota', N'Corolla SE 1.8L L4 Gas', N'Alternators', N'DB Electrical 400-40169 Alternator Compatible With/Replacement For 125 Internal Fan Type Decoupler Pulley Type Internal Regulator CW Rotation', 215.84);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(828622, 2007, N'Honda', N'Accord 2.4L L4', N'Steering Pump', N'Power Steering Pump', 68.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(293008, 2009, N'Chevrolet', N'Traverse', N'Brake Kits', N'Autospecialty Front and Rear Replacement Brake Kit-OE Brake Rotors & Ceramic Brake Pads', 315.27);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(495794, 2010, N'GMC', N'Terrain', N'Hub Assemblies', N'Front/Rear Wheel Hub Bearing Assembly', 94.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(639704, 2021, N'Kia', N'Sorento', N'Brake Kits', N'Rear Brakes and Rotors Kit |Rear Brake Pads| Brake Rotors and Pads| Optimum OEp Brake Pads and Rotors', 125.15);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(829385, 2020, N'Jeep', N'Wrangler Unlimited Sahara', N'Drum Brake', N'Centric Brake Shoe', 22.05);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(520384, 2015, N'Jeep', N'Cherokee 3.2L', N'Starters', N'DB Electrical SND0775 Starter', 94.48);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(482938, 2010, N'Honda', N'Element', N'Steering Pump', N'Power Steering Pump', 68.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(628638, 2013, N'Dodge', N'Caravan 3.8L', N'Alternators & Generators', N'Alternator', 118.37);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(397020, 2010, N'Volkswagen', N'Routan', N'Alternators', N'Alternator', 114.46);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(240850, 2010, N'Dodge', N'Caravan', N'Starters', N'DB Electrical SMT0343 Starter', 82.66);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(953814, 2007, N'Audi', N'A3 2.0T', N'Fuel System', N'High Pressure Fuel Pump', 96.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(484695, 2014, N'GMC', N'Terrain', N'Bearings & Seals', N'Front/Rear Wheel Hub Bearing Assembly 5 Lugs w/ABS', 79.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(807204, 2016, N'Chevrolet', N'Camaro', N'Alternators & Generators', N'DB Electrical Alternator', 218.74);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(838475, 2020, N'Cadillac ', N'Escalade Esv', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(939283, 2015, N'Chevrolet', N'Equinox', N'Bearings & Seals', N'Wheel Hub Bearing Assembly', 48.85);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(293007, 2011, N'Buick', N'Enclave', N'Brake Kits', N'Autospecialty Front and Rear Replacement Brake Kit-OE Brake Rotors & Ceramic Brake Pads', 315.27);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(738628, 2021, N'Toyota', N'Prius AWD-e', N'Shocks, Struts & Suspension', N'2-Piece Suspension Strut and Coil Spring Kit (593024)', 299.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(186950, 2017, N'Honda', N'CRV', N'Alternator', N'Alternator', 202.47);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(283842, 2003, N'Honda', N'Accord', N'Brake System', N'Front Vented Replacement Brake Rotors Kit - Drilled Slotted Brake Rotors & Ceramic Brake Pads', 110.58);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(329573, 2012, N'Chevrolet', N'Equinox', N'Bearings & Seals', N'Front/Rear Wheel Hub Bearing Assembly 5 Lugs w/ABS', 79.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(329583, 2017, N'GMC', N'Yukon XL', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(159937, 2010, N'Chrysler', N'Town Country 3.3L', N'Starters', N'DB Electrical SND0544 Starter', 88.88);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(594085, 2015, N'Buick', N'Regal', N'Bearings & Seals', N'Front/Rear Wheel Hub Bearing Assembly 5 Lugs w/ABS', 79.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(928405, 2018, N'Chevrolet', N'Camaro', N'Alternators & Generators', N'DB Electrical Alternator', 218.74);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(248048, 2011, N'Dodge', N'Avenger', N'Starters', N'DB Electrical SND0775 Starter', 94.48);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(927937, 2012, N'Ford', N'Focus SE', N'Starters', N'Duralast Starter 19481', 188.88);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(283948, 2018, N'GMC', N'Savana 3500', N'Shocks, Struts & Suspension', N'Suspension Kit (Front; with 3 Groove Pitman Arm)', 142.44);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(204185, 2016, N'Cadillac', N'CTS Front AWD 3.6 V6', N'Hub Assemblies', N'Front/Rear Wheel Hub Bearing Assembly', 94.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(495116, 2020, N'Chrysler', N'Voyager', N'Brake Kits', N'Power Stop K7845 Rear Z23 Carbon Fiber Brake Pads with Drilled & Slotted Brake Rotors Kit', 269.75);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(180400, 2012, N'Cadillac', N'CTS FWD', N'Bearings & Seals', N'Front/Rear Wheel Hub Bearing Assembly 5 Lugs w/ABS', 79.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(593024, 2021, N'Toyota', N'Prius', N'Shocks, Struts & Suspension', N'2-Piece Suspension Strut and Coil Spring Kit (593024)', 299.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(392703, 2010, N'Chrysler', N'Town Country 3.3L', N'Starters', N'DB Electrical SND0544 Starter', 88.88);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(749283, 2013, N'Jeep', N'Cherokee 3.2L', N'Starters', N'DB Electrical SND0775 Starter', 94.48);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(742829, 2017, N'Honda', N'Accord', N'Brake System', N'Front Vented Replacement Brake Rotors Kit - Drilled Slotted Brake Rotors & Ceramic Brake Pads', 110.58);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(302839, 2014, N'Chevrolet', N'Equinox', N'Bearings & Seals', N'Wheel Hub Bearing Assembly', 48.85);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(649394, 2020, N'Jeep', N'Wrangler Unlimited Sahara', N'Brake Kits', N'Power Stop K7940 Front Z23 Evolution Sport Brake Upgrade Kit ', 354.46);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(294857, 2020, N'Chevrolet', N'Tahoe Suburban', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(820684, 2015, N'Buick', N'LaCrosse', N'Bearings & Seals', N'Front/Rear Wheel Hub Bearing Assembly 5 Lugs w/ABS', 79.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(602839, 2017, N'GMC', N'Savana 2500', N'Shocks, Struts & Suspension', N'Suspension Kit (Front; with 3 Groove Pitman Arm)', 142.44);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(137497, 2007, N'Audi', N'A3 Quattro Base 3.2L V6 - Gas', N'Electric Fuel Pumps', N'Electric High Pressure Fuel Pump', 108.16);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(294829, 2019, N'GMC', N'Yukon XL', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(928822, 2007, N'Audi', N'A4 Quatro 2.0T BWT', N'Fuel System', N'High Pressure Fuel Pump', 96.97);
GO
INSERT INTO AutoParts(PartNumber, CarYear, Make, Model, Category, PartName, UnitPrice) VALUES(529384, 2018, N'Cadillac ', N'Escalade Esv', N'Shocks, Struts & Suspension', N'4pc set shocks and struts front and rear complete assembly magnetic ride control suspension', 655.98);
GO
  2. To execute and create the records, click the Execute button
Home Copyright © 2007-2022, FunctionX Monday 23 May 2022 Home