Question: Write an INSERT statement that adds this row to the CategoriesCopy table: CategoryName: Brass Code the INSERT statement so SQL Server automatically generates the value

Write an INSERT statement that adds this row to the CategoriesCopy 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 CategoriesCopy table. This statement should change the ProductName column to Woodwinds, and it should use the CategoryID column to identify the row.

3. Write a DELETE statement that deletes the row you added to the CategoriesCopy table in exercise 1. This statement should use the CategoryID column to identify the row.

4.Write an INSERT statement that adds this row to the ProductsCopy 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.

Use a column list for this statement.

5. Write an UPDATE statement that modifies the product you added in exercise 4. This statement should change the DiscountPercent column from 0% to 35%.

6. Write a DELETE statement that deletes the row in the CategoriesCopy table that has an ID of 4.

7. Write an INSERT statement that adds this row to the CustomersCopy table:

EmailAddress: rick@raven.com Password: (empty string) FirstName: Rick LastName: Raven

Use a column list for this statement.

8. Write an UPDATE statement that modifies the CustomersCopy table. Change the password column to secret for the customer with an email address of rick@raven.com

9.Write an UPDATE statement that modifies the CustomersCopy table. Change the password column to reset for every customer in the table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

SQL Lab Assignment 6: Answer the questions below in SQL queries. The purpose of this assignment is to demonstrate that you can execute statements that are used to add, change, and delete data in...

SQL GUITARSHOP 1. Write a Select * Into statement three times that will create the following 3 tables: Categories Products Customers Now add three Drop Table statements before the Select * Into...

A. Issue the command "Select * from Categories;" B. Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass Code the INSERT statement so SQL Server automatically...

Chapter 7 How to insert, update, and delete data Exercises To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. * *...

To test whether a table has been modified correctly as you do these exercises, you can write and run an appropriate SELECT statement. 1. Write an INSERT statement that adds this row to the Categories...

These questions use the MyGuitarShop database. 1. Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass Code the INSERT statement so SQL Server automatically...

To the best of my knowledge I would have to modify something in SQL Server 2012 to make this work. Is there some sort of screenshot or detailed instructions on what and/or how to modify in order to...

CreateMyGuitarShop.sql The database: https://pastebin.com/6704ZdGp 1. Write an INSERT statement that adds this row to the Categories table: CategoryName: Brass Code the INSERT statement so SQL Server...

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....

Find 0.900 and 0.100 probability limits for a c chart when the process average is equal to 16 nonconformities.

The Nielsen Company compiled a list of the top 25 advertisers in African American media. Shown below are a Minitab descriptive statistics analysis of the annual advertising spending in $ million by...

The change in the labor classification caused the labor rate variances. This change could also have been responsible for the direct labor time variance. true or false

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Draw up an outline plan by following the three- stage planning approach.

The models used to analyse different national cultures.

The nature of the issues associated with expatriate employment.