The users of AdventureWorks need to publish the details of all the customers and their address on the organizations website. To perform this task, you need to retrieve the data in the XML format. | 3 Cft c ft o 3 c ữ Session 9 Solutions to Exercises This session includes exercises of Chapter 5 and Chapter 6. Chapter 5 Exercise 1 Insert the following data in the ProductBrand table of the AdventureWorks database. BrandID BrandName B01 Lee B02 Nike B03 Reebok Solution You need to execute the following insert statements to create the ProductBrand table and store three records in the ProductBrand table. Create Table ProductBrand BrandID varchar 4 BrandName varchar 20 INSERT INTO ProductBrand VALUES B01 Lee INSERT INTO ProductBrand VALUES B02 Nike INSERT INTO ProductBrand VALUES B03 Reebok Exercise 2 AdventureWorks Inc. has set up a new store. Insert the following data into the database Store Name - Car Store Sales Person ID - 283 Demographics - StoreSurvey XMLns http sqlserver 2004 07 adventure-works StoreSurvey NIIT Instructor Inputs .
