P.s.: These 70-461 Exam Questions Were Updated After 2014/11/1 With The Change Of New Microsoft Exam. 100 Percent Vaild And 100 Percent Pass Ensure. Visit Our PassLeader Website And Get All Valid Exam Questions With PDF And VCE. 100 Percent Guaranteed Pass or 100 Percent Money Back Guarantee!
Exam Code: 70-461
Exam Name: Querying Microsoft SQL Server 2012
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 InventoryADD TotalItems AS ItemsInStore + ItemsInWarehouse
B. ALTER TABLE InventoryADD ItemsInStore – ItemsInWarehouse = TotalItems
C. ALTER TABLE InventoryADD TotalItems = ItemsInStore + ItemsInWarehouse
D. ALTER TABLE InventoryADD TotalItems AS SUM(ItemsInStore, ItemslnWarehouse)