logo

Using SQL to Insert Sales Data into a Database

7 Pages2895 Words180 Views
   

Added on  2019-09-16

About This Document

This is a series of SQL statements that insert data into the `Sales` table in the `AllApplianceCo` database. Each `INSERT` statement adds a new row to the table with values for the columns `FirstName`, `LastName`, `StreetAddress`, `City`, `State`, `Zipcode`, `StoreID`, `ProductID`, `Quantity`, and `SalesID`. The data being inserted represents sales transactions for various customers at different store locations.

Using SQL to Insert Sales Data into a Database

   Added on 2019-09-16

ShareRelated Documents
USE[AllApplianceCo]GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Orlando',N'Gee',N'8713 Yosemite Ct.',N'Houston',N'TX',N'77001', 11, 6, 1, 15001)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Keith',N'Harris',N'1318 Lasalle Street',N'Houston',N'TX',N'77005', 15, 1, 1,15002)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Donna',N'Carreras',N'9178 Jumping St.',N'Houston',N'TX',N'77001', 11, 1, 1,15003)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Janet',N'Gates',N'9228 Via Del Sol',N'Houston',N'TX',N'77005', 15, 2, 2, 15004)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Lucy',N'Harrington',N'26910 Indela Road',N'Tulsa',N'OK',N'74101', 13, 2, 1, 15005)GO
Using SQL to Insert Sales Data into a Database_1
INSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Rosmarie',N'Carroll',N'2681 Eagle Peak',N'Tulsa',N'OK',N'74105', 13, 2, 2, 15006)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Dominic',N'Gash',N'7943 Walnut Ave',N'Tulsa',N'OK',N'74121', 14, 1, 1, 15007)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Kathleen',N'Garza',N'6388 Lake City Way',N'Tulsa',N'OK',N'74129', 14, 3, 2, 15008)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Katherine',N'Harding',N'52560 Free Street',N'Tulsa',N'OK',N'74129', 14, 4, 1,15009)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Johnny',N'Caprio',N'22580 Free Street',N'Tulsa',N'OK',N'74133', 13, 2, 1,15010)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])
Using SQL to Insert Sales Data into a Database_2
VALUES (N'Christopher',N'Beck',N'2575 Bloor Street East',N'Memphis',N'TN',N'38105', 17, 2,1, 15011)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'David',N'Liu',N'1484 Jacob Road',N'Memphis',N'TN',N'38108', 17, 3, 1, 15012)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'John',N'Beaver',N'575 Rue St Amable',N'Memphis',N'TN',N'38109', 17, 2, 1, 15013)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Jean',N'Handley',N'2512-4th Ave Sw',N'Memphis',N'TN',N'38109', 17, 3, 2, 15014)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Jinghao',N'Liu',N'55 Lakeshore Blvd East',N'Memphis',N'TN',N'38101', 17, 5, 1,15015)GOINSERT[dbo].[Sales]([FirstName],[LastName],[StreetAddress],[City],[State],[Zipcode],[StoreID],[ProductID],[Quantity],[SalesID])VALUES (N'Linda',N'Burnett',N'6333 Cote Vertu',N'Memphis',N'TN',N'38102', 17, 3, 2, 15016)GO
Using SQL to Insert Sales Data into a Database_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Business Data Management and Analytics Assignment 2022
|10
|1141
|5