Question: Write a script that creates a table named ProductDescriptions. This table should have three columns. The first column should be an identity column named DescriptionsID,

Write a script that creates a table named ProductDescriptions. This table should have three columns. The first column should be an identity column named DescriptionsID, the second column should be a foreign key column named ProductID, and the third column should be an xml column named Description.

Then, insert a new row into the ProductDescriptions table that contains the data stored in the ProductDescription.xml file thats in the Exercise Starts directory. This data should be related to the product with an ID of 1.

Finally, select all rows from this 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!

I need som help with this sql project. In this exercise, you will create two users and a role. You will grant privileges directly to the first user, but you will grant privileges to the second user...

Good evening need some Oracle/SQL help please 1. Use the CUSTOMERS table Display the number of months between the order _date for the customer with customer _ id of 8 and todays date. Round to the...

5 . Write a script that creates and calls a stored procedure named spUpdateInstructor that updates the AnnualSalary column in the Instructors table. This procedure should have one parameter for the...

Write a script that creates and calls a stored procedure named spUpdateProductDiscount that updates the DiscountPercent column in the Products table. This procedure should have one parameter for the...

Write a script that creates a table structure to store materials properties. The table structure should be named MaterialProperties and should include the following column variables ( in order )...

Name \ table [ [ Density , Yield,Elasticity ] , [ 7 8 0 0 , 2 5 0 , 2 0 0 ] , [ 2 7 0 0 , 2 7 6 , 6 8 . 9 ] ] Write a script that creates a table structure to store materials properties. First create...

\ table [ [ Name , Density,Yield,Elasticity, ] , [ ' A - 3 6 Structural Steel',,,, ] , [ ' 6 0 6 1 - T 6 Aluminum',,,, ] , [ , 2 7 0 0 , , 2 5 0 , 2 0 0 ] , [ , , , 2 7 6 , 6 8 . 9 ] ] Write a script...

Use the following structure for problem 1. struct student{ string name; int id; float mark; }; Declare an array named studentArray of the structure type shown above, the size of the array is limited...

Use C++ language to develop an original implementation of a menu-driven program performing a number of tasks relating to students details: displaying all students details, adding new student to the...

Obesity is becoming one of the major health problems in the society due to bad feeding habits. (a) Define Obesity(2 mks) (b) Enumerateten (10) causes of obesity.(5 mks) (c) Describe three (3)...

How to study the regulatory function of Non coding RNAs?

True or false: The depreciation tax shield is the depreciation deduction divided by the tax rate. True False The rules for depreciating assets for tax purposes are based upon provisions in the: 1 9 8...

The standard deviation of return on investment A is 12%, while the standard deviation of return on investment B is 7%. If the covariance between the returns on A and B is 0.001 , the correlation of...

1. What do you think is going on here? What are the elements of organizational politics that may be operating here? Power dynamics?

4. How comfortable are you with introducing yourself to people? What kind of impression do you think you give others? (You may want to check your self-assessment by asking a trusted source what kind...

5. Under what circumstances is introducing yourself to someone you dont know a good idea? When is introducing yourself not such a good idea?