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; Almond, 1;
Nyanza, 1.
...
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; Almond, 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]
