You develop a Microsoft SQL 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?
ngocyw
1 year, 1 month agoAnapuspita
5 years, 5 months ago