Create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. The new column is expected to be queried heavily, and you need to be able to index the column. Which Transact-SQL statement should you use?

Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 3226 | Points: 40

Select from following answers:

ALTER TABLE Inventory ADD TotalItems AS ItemslnStore + ItemsInWarehouse
ALTER TABLE Inventory ADD TotalItems AS ItemslnStore + ItemsInWarehouse Persisted
ALTER TABLE Inventory ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse) PERSISTED
ALTER TABLE Inventory ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)
All Above