Question: Exercise 14-4 [20 points] Write a script that attempts to insert a new category named Guitars into the Categories table. If the insert is successful,

Exercise 14-4 [20 points] Write a script that attempts to insert a new category named Guitars into the Categories table. If the insert is successful, the script should display this message:

SUCCESS: Record was inserted.

If the update is unsuccessful, the script should display a message something like this:

FAILURE: Record was not inserted. Error 2627: Violation of UNIQUE KEY constraint 'UQ__Categori__8517B2E0A87CE853'. Cannot insert duplicate key in object 'dbo.Categories'. The duplicate key value is (Guitars).

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!

DATABASES BELOW: CREATE TABLE Categories ( CategoryID INT PRIMARY KEY IDENTITY, CategoryName VARCHAR(255) NOT NULL UNIQUE ); CREATE TABLE Products ( ProductID INT PRIMARY KEY IDENTITY, CategoryID INT...

3. Write a script that attempts to insert a new category named Guitars into the Categories table. If the insert is successful, the script should display this message: SUCCESS: Record was inserted....

If the update is unsuccessful, the script should display a message something like this: FAILURE: Record was not inserted. Error 2627: Violation of UNIQUE KEY constraint...

Write a script that attempts to insert a new division named "Guitars" into the Division table. If the insert is successful, the script should display this message: SUCCESS: Record was inserted. If...

Write a script that attempts to insert a new category named "Guitars" into the Categories table. If the insert is successful, the script should display this message: SUCCESS: Record was inserted. If...

Write a script that creates and calls a stored procedure named test. This stored procedure should declare a variable and set it to the count of all products in the Products table. If the count is...

You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL statement. Please number your answers from 1...

creating a sql for the guitar shop You will use SQL and My Guitar Shop database to create SQL statements. Save your select statements as a script. Place the semicolon at the end of each SQL...

What is Glocalization? Define and discuss its importance?

Indicate the characteristics of the o- in the carbonyl. And an example.

Par value is the dollar value that an investor must pay in order to purchase preferred stock. Question 242 options: True False

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Understand some of the infl uences on the business environment that have changed the approaches to employing people.

Design a job advertisement.

10-20 Describe the six features of social commerce. Provide an example for each feature describing how a business could use that feature for selling to consumers on line.