You are designing a Microsoft SQL Server database named Orders. You create a table according to the following schema: You create a stored procedure to be used by an ASP.NET application that runs the following statement: You need to ensure…

You use Microsoft Azure SQL Database to develop a database application. You create a stored procedure named dbo.InsertData. dbo.InsertData uses multiple batch statements to calculate a column named RateofChange and insert data one row at a time. You need to…

DRAG DROP You use Microsoft SQL Server to develop a database application. You execute a stored procedure named PriceIncreasePct that has multiple statements. You need to ensure that the calling application can find out the exact error message if an…

DRAG DROP You have a Microsoft SQL Server database. The database contains a group of tables created by using the following Transact-SQL statements: You need to write a query that returns all the salesperson’s phone numbers and an indicator as…

You are developing a Microsoft SQL Server database. You write a query that returns the median value of SalesYTD for each TerritoryID. You need to ensure that the query returns the most accurate median value, even if there is no…

DRAG DROP You are developing a Microsoft SQL Server database: You have the following requirements: • Data should use the least storage space. • Data should not lose precision. Which storage type or types should you use? To answer, drag…

You are developing an application that uses data residing in two databases named Inventory and Accounting on a single Microsoft SQL Server 2012 server. You plan to provide a record set from tables in the Inventory database. You write the…

You need to design a table for a customer management application that will store a list of country names. The table must meet the following requirements: • Country names must be stored in English only. • The disk space used…

You administer a Microsoft SQL Server database named ContosoDb. Tables are defined as shown in the exhibit. (Click the Exhibit button.) You need to display rows from the Orders table for the Customers row having the CustomerId value set to…

You develop a Microsoft SQL Server database that contains a table named Employee, defined as follows: You need to create a view that contains two computed columns representing the month and the year of the [HireDate] of each Employee. Which…