To the best of my knowledge I would have to modify something in SQL Server 2012

Question

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 make this work? Hopefully this will clarify the question,

Thanks.

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 CategoryName 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: Today’s 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 .  

7. Write a DELETE statement that deletes rows from the Products table for products that do not have any orders for that Product.

Explanation / Answer

1. Insert into Categories(CategoryName) values('Brass');

2. update Categories set CategoryName='Woodwinds' where CatogeryID= (give id you want here);

3. insert into Products( ProductID,CategoryID,ProductCode,ProductName,Description,ListPrice,DiscountPercent,DateAdded) values (ProductID.seq,4,'dgx_640','Yamaha DGX 640 88- Key Digital Piano','description write here which u want',799.99,0,CURRENT_TIMESTAMP);

4. To delete the row of the Category with ID=4 from the products table.

Delete from products where CategoryID=4;

To delete the row from the Category with ID=4 from Categories table.

Delete from Categories where CategoryID=4;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.