You administer a Microsoft SQL Server 2008 database that contains a table named Sales.SalesOrderHeader. The Sales.SalesOrderHeader table has the following definition:
CREATE TABLE [Sales].[SalesOrderHeader](
[SalesOrderID] [int] IDENTITY(1,1) NOT NULL,
[OrderDate] [datetime] NOT NULL,
[DueDate] [datetime] NOT NULL,
[ShipDate] [datetime] NULL,
[Status] [tinyint] NOT NULL,
[CustomerID] [int] NOT NULL,
[SalesPersonID] [int] NULL,
[SubTotal] [money] NOT NULL,
[TaxAmt] [money] NOT NULL,
CONSTRAINT [PK_OrderHeader_SalesOrderID] PRIMARY KEY CLUSTERED ([SalesOrderID] ASC) ) ON [PRIMARY]
GO
You plan to perform the following tasks:
•Display all Sales.SalesOrderHeader records that contain orders that have not been shipped.
•Generate an execution plan of XML output document for the query.
You need to ensure that the following requirements are met:
•Data is returned for all fields in the Sales.SalesOrderHeader table where the shipping date is unknown.
•An XML document is provided only for this query.
•An XML document that contains the actual execution plan is returned.
Which three Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)
Build List and Reorder:
