高难度问题？？？？？？？？？？

Question

找出这个视图的有日期字段的基表，dbcc checktable('表名'),贴出结果看看

Answer 1

Xs_OrderBillMain的 DBCC 结果。
对象 'Xs_OrderBillMain' 的 1457 页中有 26743 行。
DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。

Answer 2

SELECT     TOP (100) PERCENT dbo.Xs_OrderBillMain.OrderBillMainID, dbo.Xs_OrderBillMain.OrderCode, dbo.Xs_OrderBillMain.OrderDate, 
                      dbo.Xs_OrderBillMain.ContractCode, dbo.Xs_OrderBillMain.KjYear, dbo.Xs_OrderBillMain.Period, dbo.Xs_OrderBillMain.ConsignAddress, 
                      dbo.Xs_OrderBillMain.SellerSigner, dbo.Xs_OrderBillMain.BuyerSigner, dbo.Xs_OrderBillMain.SignAddress, dbo.Xs_OrderBillMain.TransferWayCode, 
                      dbo.Xs_OrderBillMain.PayCode, dbo.Xs_OrderBillMain.Ernest, dbo.Xs_OrderBillMain.ExchRate, dbo.Xs_OrderBillMain.SellTypeCode, 
                      dbo.Xs_OrderBillMain.ForeignCurrCode, dbo.Xs_OrderBillMain.PersonCode, dbo.Xs_OrderBillMain.DeptCode, dbo.Xs_OrderBillMain.CusCode, 
                      dbo.Xs_OrderBillMain.Maker, dbo.Xs_OrderBillMain.MakerDate, dbo.Xs_OrderBillMain.Checker, dbo.Xs_OrderBillMain.Closer, 
                      dbo.Xs_OrderBillMain.CloseCause, dbo.Xs_OrderBillMain.CloseDate, dbo.Xs_OrderBillMain.ConvertFlag, dbo.Xs_OrderBillMain.Re, 
                      dbo.Xs_SellType.SellTypeName, dbo.Gy_TransferWay.TransferWayName, dbo.Gy_ForeignCurrency.ForeignCurrName, dbo.Gy_Department.DeptName,
                       dbo.Gy_Person.PersonName, dbo.Gy_Customer.CusName, dbo.Xs_OrderBillMain.QuotationMainID, dbo.Xs_OrderBillMain.QuotationCode, 
                      dbo.Xs_OrderBillMain.ContractMainID, dbo.Xs_OrderBillMain.jianshu, dbo.Xs_OrderBillMain.tiji, dbo.Xs_OrderBillMain.orderflag, 
                      dbo.Xs_ConsignBillMain.ConsignDate, dbo.Xs_ConsignBillMain.sjfhrq, dbo.Xs_ConsignBillMain.sj, dbo.Gy_TransferCompany.TranCompanyName, 
                      dbo.Xs_ConsignBillMain.hzysd, dbo.Gy_Customer.TradeCode, dbo.Gy_Customer.CusSuper, dbo.Xs_OrderBillMain.cwhxrq, 
                      dbo.XS_OrderBillSub.OrderBillSubID, dbo.XS_OrderBillSub.WareCode, dbo.XS_OrderBillSub.PrepareDate, dbo.XS_OrderBillSub.Quantity, 
                      dbo.XS_OrderBillSub.UnitPrice, dbo.XS_OrderBillSub.TaxRate, dbo.XS_OrderBillSub.TaxUnitPrice, dbo.XS_OrderBillSub.TaxMoney, 
                      dbo.XS_OrderBillSub.OrderMoney, dbo.XS_OrderBillSub.WholeMoney, dbo.XS_OrderBillSub.CapitalUnitPrice, 
                      dbo.XS_OrderBillSub.CapitalTaxUnitPrice, dbo.XS_OrderBillSub.CapitalMoney, dbo.XS_OrderBillSub.CapitalTax, 
                      dbo.XS_OrderBillSub.CapitalWholeMoney, dbo.XS_OrderBillSub.CapConsignMoney, dbo.XS_OrderBillSub.ConsignMoney, 
                      dbo.XS_OrderBillSub.ConsignQuantity, dbo.XS_OrderBillSub.InvoiceQuantity, dbo.XS_OrderBillSub.CapInvoiceMoney, 
                      dbo.XS_OrderBillSub.InvoiceMoney, dbo.XS_OrderBillSub.ReturnMoney, dbo.XS_OrderBillSub.CapReturnMoney, 
                      dbo.XS_OrderBillSub.Re AS Expr1, dbo.XS_OrderBillSub.checker AS Expr2, dbo.XS_OrderBillSub.jians, dbo.XS_OrderBillSub.txm, 
                      dbo.XS_OrderBillSub.cxgj
FROM         dbo.Xs_OrderBillMain RIGHT OUTER JOIN
                      dbo.XS_OrderBillSub ON dbo.Xs_OrderBillMain.OrderBillMainID = dbo.XS_OrderBillSub.OrderBillMainID LEFT OUTER JOIN
                      dbo.Xs_ConsignBillMain LEFT OUTER JOIN
                      dbo.Gy_TransferCompany ON dbo.Xs_ConsignBillMain.TranCompanyCode = dbo.Gy_TransferCompany.TranCompanyCode ON 
                      dbo.Xs_OrderBillMain.OrderBillMainID = dbo.Xs_ConsignBillMain.OrderBillMainID LEFT OUTER JOIN
                      dbo.Gy_TransferWay ON dbo.Xs_OrderBillMain.TransferWayCode = dbo.Gy_TransferWay.TransferWayCode LEFT OUTER JOIN
                      dbo.Gy_ForeignCurrency ON dbo.Xs_OrderBillMain.ForeignCurrCode = dbo.Gy_ForeignCurrency.ForeignCurrCode LEFT OUTER JOIN
                      dbo.Xs_SellType ON dbo.Xs_OrderBillMain.SellTypeCode = dbo.Xs_SellType.SellTypeCode LEFT OUTER JOIN
                      dbo.Gy_Department ON dbo.Xs_OrderBillMain.DeptCode = dbo.Gy_Department.DeptCode LEFT OUTER JOIN
                      dbo.Gy_Person ON dbo.Xs_OrderBillMain.PersonCode = dbo.Gy_Person.PersonCode LEFT OUTER JOIN
                      dbo.Gy_Customer ON dbo.Xs_OrderBillMain.CusCode = dbo.Gy_Customer.CusCode
ORDER BY dbo.Xs_OrderBillMain.OrderDate DESC

Answer 3

把TOP (100) PERCENT去掉试试

Answer 4

from改成全left joinFROM                  dbo.XS_OrderBillSub LEFT OUTER JOIN
                      dbo.Xs_OrderBillMain ON dbo.Xs_OrderBillMain.OrderBillMainID = dbo.XS_OrderBillSub.OrderBillMainID LEFT OUTER JOIN
                      dbo.Xs_ConsignBillMain LEFT OUTER JOIN
                      dbo.Gy_TransferCompany ON dbo.Xs_ConsignBillMain.TranCompanyCode = dbo.Gy_TransferCompany.TranCompanyCode ON 
                      dbo.Xs_OrderBillMain.OrderBillMainID = dbo.Xs_ConsignBillMain.OrderBillMainID LEFT OUTER JOIN
                      dbo.Gy_TransferWay ON dbo.Xs_OrderBillMain.TransferWayCode = dbo.Gy_TransferWay.TransferWayCode LEFT OUTER JOIN
                      dbo.Gy_ForeignCurrency ON dbo.Xs_OrderBillMain.ForeignCurrCode = dbo.Gy_ForeignCurrency.ForeignCurrCode LEFT OUTER JOIN
                      dbo.Xs_SellType ON dbo.Xs_OrderBillMain.SellTypeCode = dbo.Xs_SellType.SellTypeCode LEFT OUTER JOIN
                      dbo.Gy_Department ON dbo.Xs_OrderBillMain.DeptCode = dbo.Gy_Department.DeptCode LEFT OUTER JOIN
                      dbo.Gy_Person ON dbo.Xs_OrderBillMain.PersonCode = dbo.Gy_Person.PersonCode LEFT OUTER JOIN
                      dbo.Gy_Customer ON dbo.Xs_OrderBillMain.CusCode = dbo.Gy_Customer.CusCode
--有个表的left join 没有条件？