Quiz 70-461

Quiz 70-461, Querying Microsoft SQL Server 2012

You need to create a query that calculates the total sales of each OrderlD from a table named Sales.Details

You need to declare a variable of the XML type named invoice

You need to create an inline table-valued function named Sales.fn_OrdersByTerritory

You need to create a query that meets the following requirements: References columns by using one-part names only

You need to create a query for a report

You need to create a query that returns a list of products from Sales.ProductCatalog

What should you create for each application?

Which Transact-SQL query should you create?

Which data type should you use?

You need to ensure that the following requirements are met: The fields must use the minimum amount of space