week_8_LABS.docx.pdf

Document Content and Description Below

LAB 24 Part 1 Using WideWorldImporters and the Warehouse schema add the following values to the Colors table for the columns ColorName and LastEditedBy: Dark Gray, 1; Scarlet, 1; Light Gray, 1; Alm... ond, 1; Nyanza, 1. Take a screen shot of the SQL windows and results and paste it here. Part 2 Write a query to select all rows from the table Colors that were added in Part 1. Take a screen shot of the SQL windows and results This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 13:34:09 GMT -05:00 https://www.coursehero.com/file/84119747/week-8-LABSdocx/and paste it here. Part 3 Write a query to select all rows from the temporal table for Colors. Take a screen shot of the SQL windows and results and paste it here. Part 4 Change the values of LastEditedBy for the rows added in Part 1 to a 9. Take a screen shot of the SQL windows and results and paste it This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 13:34:09 GMT -05:00 https://www.coursehero.com/file/84119747/week-8-LABSdocx/here. Part 5 Write a query to select all rows from the temporal table for Colors. Take a screen shot of the SQL windows and results and paste it here. This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 13:34:09 GMT -05:00 https://www.coursehero.com/file/84119747/week-8-LABSdocx/LAB 25 Part 1Using the WideWorldImporters database and the Warehouse schema write a query that returns the result set transformed to XML data. The query will return StockItemID, StockItemName, Brand, Size, TaxRate, UnitPrice, ValidFrom and ValidTo from the table StockItems. The XML file will have the following structure: root name will be InventoryInfo, the path name will be Product. StockItemId will be an attribute of the path name. StockItemName and UnitPrice will be elements of the path name. Brand and Size will be attributes of an element named Descriptioin in the path name. TaxRate will be an attribute of an element named TaxInfo in the path name. ValidFrom This study source was downloaded by 100000822447745 from CourseHero.com on 07-17-2022 13:34:09 GMT -05:00 https://www.coursehero.com/file/84119747/week-8-LABSdocx/and ValidTo will be child elements of an element named ValidDates in the path name. Take a screen shot of the SQL windows and results and paste it here. [Show More]

Last updated: 1 year ago

Preview 1 out of 7 pages