????4?????????????3?е???м??????????SalesOrdDemo?????о????????裬???????????????WHERE????????SalesOrderID?С???SalesOrderDetails???з?????????衣??????????????????????????к?????

????5??????????????±??DueDate??????????????????????????в????????????????檔

CREATE STATISTICS st_SaledOrdDemo_DueDate ON SalesOrdDemo(DueDate)
GO

????6???????в???3????????????κθ????

SELECT  s.salesorderid ??
        so.SalesOrderDetailID
FROM    salesordDemo AS s
        INNER JOIN Sales.SalesOrderDetail AS so ON s.salesorderid = so.SalesOrderID
WHERE   s.duedate = '2005-09-19 00:00:00.000'

????7????????????м?????????SalesOrderDetails??????????????????????????????????????????2%???????????????????????????????????

??????????

??????????????????ν?????е???????????????????????????????????????????????????з????