PricingBlogAbout Us

SQL Sales Data Insertion Script

Verified

Added on  2019/09/16

|7
|2895
|180
Practical Assignment
AI Summary
This content provides a detailed SQL script designed to insert sales data into the 'Sales' table of the 'AllApplianceCo' database. The script includes multiple INSERT statements, each adding a new sales record with specific details such as customer names, addresses, store IDs, product IDs, quantities, and unique sales IDs. The script is written in T-SQL and is intended for use in a SQL Server environment. This resource is beneficial for students learning about database management and SQL data manipulation.
Document Page
USE [AllApplianceCo]
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
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)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
Document Page
VALUES (N'Christopher', N'Beck', N'2575 Bloor
Street East', N'Memphis', N'TN', N'38105', 17, 2,
1, 15011)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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)
GO
INSERT [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

⊘ This is a preview!⊘

Do you want full access?

icon

Trusted by 1+ million students worldwide

Document Page
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Kerim', N'Hanif', N'3255 Front Street
West', N'Memphis', N'TN', N'38102', 17, 2, 1,
15017)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Kevin', N'Liu', N'2550 Signet Drive',
N'Memphis', N'TN', N'38103', 17, 2, 1, 15018)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Donald', N'Blanton', N'6777 Kingsway',
N'Houston', N'TX', N'77001', 11, 7, 2, 15019)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jackie', N'Blackwell', N'5250 Burning
St', N'Houston', N'TX', N'77005', 15, 1, 1, 15020)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Bryan', N'Hamilton', N'600 Slater
Street', N'Houston', N'TX', N'77001', 11, 6, 2,
15021)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
tabler-icon-diamond-filled.svg

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
Document Page
VALUES (N'Todd', N'Logan', N'25575 The Queensway',
N'Houston', N'TX', N'77005', 15, 2, 2, 15022)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Barbara', N'German', N'2521 McPherson
Street', N'Tulsa', N'OK', N'74101', 13, 2, 1,
15023)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jim', N'Geist', N'2560 Bay Street',
N'Tulsa', N'OK', N'74105', 13, 2, 1, 15024)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Betty', N'Haines', N'630 University
Avenue', N'Tulsa', N'OK', N'74121', 14, 3, 2,
15025)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Sharon', N'Looney', N'992 St Clair Ave
East', N'Tulsa', N'OK', N'74129', 14, 3, 2, 15026)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Darren', N'Gehring', N'99, Rue Saint-
pierre', N'Tulsa', N'OK', N'74129', 14, 4, 2,
15027)
Document Page
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Erin', N'Hagens', N'25245 Sherbrooke
St', N'Tulsa', N'OK', N'74133', 13, 2, 1, 15028)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Jeremy', N'Los', N'655-4th Ave S.W.',
N'Houston', N'TX', N'77017', 11, 1, 1, 15029)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Elsa', N'Leavitt', N'25900-700-9th Ave
S.W.', N'Houston', N'TX', N'77021', 11, 6, 1,
15030)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'David', N'Lawrence', N'Po Box 83270',
N'Houston', N'TX', N'77021', 15, 1, 2, 15031)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Hattie', N'Haemon', N'400 West Pender
St', N'Houston', N'TX', N'77013', 15, 2, 1, 15032)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])

⊘ This is a preview!⊘

Do you want full access?

icon

Trusted by 1+ million students worldwide

Document Page
VALUES (N'Orlando', N'Gee', N'8713 Yosemite Ct.',
N'Houston', N'TX', N'77001', 11, 1, 1, 15033)
GO
INSERT [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', 11, 6, 1,
15034)
GO
INSERT [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', 15, 2, 1,
15035)
GO
INSERT [dbo].[Sales] ([FirstName], [LastName],
[StreetAddress], [City], [State], [Zipcode],
[StoreID], [ProductID], [Quantity], [SalesID])
VALUES (N'Robert', N'Jones', N'14Jones St',
N'Houston', N'TX', N'77001', 11, 6, 1, 15036)
GO
chevron_up_icon
1 out of 7
circle_padding
hide_on_mobile
zoom_out_icon
logo.png

Your All-in-One AI-Powered Toolkit for Academic Success.

  +13062052269
info@desklib.com

Available 24*7 on WhatsApp / Email

[object Object]
Unlock your academic potential

Copyright © 2020–2025 A2Z Services. All Rights Reserved. Developed and managed by ZUCOL.