Which Transact-SQL statement should you use?

You develop a Microsoft SQL Server 2012 server database that supports an application. The application
contains a table that has the following definition:
CREATE TABLE Inventory
(ItemID int NOT NULL PRIMARY KEY,
ItemsInStore int NOT NULL,
ItemsInWarehouse int NOT NULL)
You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse
values for each row. Which Transact-SQL statement should you use?

You develop a Microsoft SQL Server 2012 server database that supports an application. The application
contains a table that has the following definition:
CREATE TABLE Inventory
(ItemID int NOT NULL PRIMARY KEY,
ItemsInStore int NOT NULL,
ItemsInWarehouse int NOT NULL)
You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse
values for each row. Which Transact-SQL statement should you use?

A.
ALTER TABLE Inventory
ADD TotalItems AS ItemsInStore + ItemsInWarehouse

B.
ALTER TABLE Inventory
ADD ItemsInStore – ItemsInWarehouse = TotalItems

C.
ALTER TABLE Inventory
ADD TotalItems = ItemsInStore + ItemsInWarehouse

D.
ALTER TABLE Inventory
ADD TotalItems AS SUM(ItemsInStore, ItemslnWarehouse);

Explanation:
Verified answer as correct.
Reference: http://technet.microsoft.com/en-us/library/ms190273.aspx



Leave a Reply 2

Your email address will not be published. Required fields are marked *