logo

SQL Database Insert and Retrieve

   

Added on  2019-09-16

7 Pages2895 Words180 Views
 | 
 | 
 | 
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
SQL Database Insert and Retrieve_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])
SQL Database Insert and Retrieve_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
SQL Database Insert and Retrieve_3

End of preview

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

Related Documents