Write a DELETE statement that deletes the row you added to t

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

(EXERCISE 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 tor the CategoryID column.)

Solution

Exercise 1:

INSERT INTO Categories (CategoryID) VALUES (\'Brass\') ;

Now delete this added row:

DELETE FROM Categories WHERE CategoryID=\'Brass\' ;