Question
1. Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass Code the INSERT statement so SQL Server automatically generates the
1. Write an INSERT statement that adds this row to the Categories table:
CategoryName: Brass
Code the INSERT statement so SQL Server automatically generates the value for the CategoryID column.
2. Write an UPDATE statement that modifies the row you just added to the Categories table. This statement should change the Category Name column to Woodwinds, and it should use the CategoryID column to identify the row.
3.Write an INSERT statement that adds this row to the Products table: ProductID: The next automatically generated ID CategoryID: 4 ProductCode: dgx_640 ProductName: Yamaha DGX 640 88-Key Digital Piano Description: Long description to come. ListPrice: 799.99 DiscountPercent: 0 DateAdded: Todays date/time (note: be sure to use a function, not hard-coded). Use a column list for this statement.
4. Write a DELETE statement that deletes the row in the Categories table that has an ID of 4. When you execute this statement, it will produce an error since the category has related rows in the Products table. To fix that, precede the DELETE statement with another DELETE statement that deletes all products in this category.
5. Write an UPDATE statement that modifies the Customers table. Change the password column to reset for every customer in the table.
6. Modify the UPDATE statement in #5 to change the password column to reset for only the customer with an email address of barryz@raven.com
7. Write a DELETE statement that deletes rows from the Products table for products that do not have any orders for that Products.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started