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.
Answer: See the explanation
Explanation:
CREATE TABLE OrderDetails
(
ListPrice money NOT NULL,
Quantity int NOT NULL,
LineItemTotal AS (ListPrice * Quantity) PERSISTED
)
CREATE TABLE OredrDetails (
ListPrice money NOT NULL,
Quantity int NOT NULL,
LinelItemTotal AS (ListPrice*Quantity) PERSISTED )
CREATE TABLE OredrDetails (
ListPrice money NOT NULL,
Quantity int NOT NULL,
LinelItemTotal AS (ListPrice*Quantity) PERSISTED )
Create table OrderDetails
(ListPrice money Not Null,
Quantity int not Null
LineItemTotal as (ListPrice*Quantity) Presisted)