DRAG DROP
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: 
Explanation:
5-6-2
0
0
Agree.
CREATE FUNCTION udf_price_index(@actualprice numeric(16,9), @predictedprice numeric(16,9))
RETURNS float
AS
BEGIN
DECLARE @priceindex numeric(16,9)
SELECT @priceindex= CASE WHEN @predictedprice=0 THEN 0
ELSE @actualprice/@predictedprice
END
END
RETURN @priceindex
END
GO
ALTER TABLE Prices
ADD [PriceIndex] AS dbo.udf_price_index([ActualPrice], [PredictedPrice]) persisted
0
0
Correct
0
1