Monday 7 October 2013

15. AdventureWorks, Inc. has set up a new store. Insert the data into the database as shown in the following table.





















Insert into sales.Customervalus(7,'s',Default, Default)



Insert into sales.store valus(29484,'car store',285,
'<StoreSurvey XMLnas="htty://schemas.microsoft.com/sqlserver/2004/07/adventure-
works/StoreSurvey">'
<AnnualSales>350000</AnnualSales><AnnualRevenue>35000</AnnualRevenue>
<BankName>International Bank</BankName><BusinessType>BM</BusinessType>
<YearOpened>1980</YearOpened><Specialty>Road</Specialty>
<SquareFeet>7500</SquareFeet><Brands>AW</Brands><Internet>T1</Internet>
<NumberEmployees>7</NumberEmployees></storeSurvey>',Default,Default)

No comments:

Post a Comment