CORRECT TEXT
You need to create a table named OrderDetails on a new server. OrderDetails must meet the following requirements:
• Contain a new column named LineltemTotal that stores the product of ListPrice and Quantity for each row.
• The calculation for a line item total must not be run every time the table is queried. The code must NOT use any object delimiters.
• The solution must ensure that LineItemTotal is stored as the last column in the table.
Part of the correct T-SQL statement has been provided in the answer area. Provide the complete code.
A. Please review the part for this answer
“Part of the correct T-SQL statement has been provided in the answer area. ”
No it has NOT.
CREATE TABLE OrderDetails
(
ListPrice money NOT NULL,
Quantity int NOT NULL,
LineItemTotal AS (ListPrice * Quantity) PERSISTED
)