You create a stored procedure that will update multiple tables within a transaction. You need to ensure that if the stored procedure raises a run-time error, the entire transaction is terminated and rolled back. Which Transact-SQL statement should you include…

You have a Microsoft SQL Server 2012 database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to create a query that meets the following requirements: • Returns the CustomerName for…

CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You deploy a new server that has SQL Server 2012 installed. You need to create a table named Sales.OrderDetails on the new…

CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You need to create a view named uv_CustomerFullName to meet the following requirements: • The code must NOT include object delimiters. •…

CORRECT TEXT You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.) You need to create a query that calculates the total sales of each OrderId from the Sales.Details table. The solution must meet…

CORRECT TEXT You have a view that was created by using the following code: You need to create an inline table-valued function named Sales.fn_OrdersByTerritory, which must meet the following requirements: • Accept the @T integer parameter. • Use one-part names…

You develop a database for a travel application. You need to design tables and other database objects. You create a stored procedure. You need to supply the stored procedure with multiple event names and their dates as parameters. What should…

You develop a database for a travel application. You need to design tables and other database objects. You create the Airline_Schedules table. You need to store the departure and arrival dates and times of flights along with time zone information.…

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 develop a Microsoft SQL Server 2012 database. You create a view from the Orders and OrderDetails tables by using the following definition. You need to improve the performance of the view by persisting data to disk. What should you…