Question: / * 4 . Write a script with a TRY...CATCH statement that attempts to insert a new category named Guitars into the Categories table. If

/*4. Write a script with a TRY...CATCH statement 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 insert is unsuccessful, the script should use the ERROR_NUMBER and ERROR_MESSAGE
functions to display a message similar to this one:
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!

Q:

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

Q:

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

Q:

Lab Assignment 6: The purpose of this assignment is to demonstrate that you can execute statements that are used to add, change, and delete data in relational database tables. These problems require...

Q:

HW5: Chapters 7&8 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...

Q:

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

Q:

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

Q:

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

Q:

database management 2 1. (15) Write a script that uses three variables to store (1) the count of distinct orders made in the Orders table (2) the total amount of sales sales means the price of the...

Q:

1. (15) Write a script that uses three variables to store (1) the count of distinct orders made in the Orders table (2) the total amount of sales (sales means the price of the item with discount...

Q:

category_list.php Category List Name Add Category List Products index.php category_db.php product_list.php Categories "> "> product_view.php Categories "> List Price: $ Discount: % Your Price: $ (You...

Q:

On January 1, 2020, Julius Company acquired 40% interest in Ella Company for P4,800,000. Julius already had 25% interest which had been acquired for P1,600,000. The fair value of the identifiable net...

Q:

Prepare a bank reconciliation for Cole Co. assuming the following as of May 31. Use the worksheet provided in the Ch 7 Module: 1) The company's cash account as a debit balance of: $95,250 2) The bank...

Q:

the phrases "fully tenanted" or "fully leased." How much vacancy is there in this scenario? A range is acceptable

Q:

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Q:

3. How do you benefit or have been disenfranchised in the telling of certain histories? How do you take responsibility for the histories from which you benefit?

Q:

c. What are common stereotypes about the group? How did these stereotypes originate?

Q:

6. How do histories influence the process of identity formation?