You use Microsoft SQL Server 2012 to develop a database application. You create a table by using
the following definition:
CREATE TABLE Prices ( PriceId int IDENTITY(1,1) PRIMARY KEY,
ActualPrice NUMERIC(16,9), PredictedPrice
NUMERIC(16,9))
You need to create a computed column based on a user-defined function named udf_price_index.
You also need to ensure that the column supports an index. Which three Transact-SQL statements
should you use? (To answer, move the appropriate SQL statements from the list of statements to
the answer area and arrange them in the correct order.)
Answer: 
why persisted?
0
0
because “You also need to ensure that the column supports an index”
0
0
i can run this codes
create table dbo.Prices(
PriceID int IDENTITY(1,1) PRIMARY KEY,
ActualPrice NUMERIC(16,9),
PredictedPrice NUMERIC(16,9)
)
CREATE FUNCTION
udf_price_index
(@actualPrice NUMERIC(16,9),
@predictedprice NUMERIC(16,9))
RETURNS NUMERIC(16,9)
WITH SCHEMABINDING
AS
BEGIN
DECLARE @priceindex NUMERIC(16,9)
select @priceindex = case
WHEN @predictedprice = 0 Then 0
ELSE
@actualPrice/@predictedprice
END
RETURN @priceindex
END
ALTER TABLE dbo.prices add [PriceIndex]
AS dbo.udf_price_index(ActualPrice,PredictedPrice)
create NONCLUSTERED INDEX IdxPriceIndex
on dbo.Prices([PriceIndex])
0
0