经过我的反复测试 证明下面这段话有问题 但又不知道问题在哪里?下面是代码SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[ViewBill] AS SELECT TOP (100) PERCENT a.CustomerName, a.BId, a.ClientId, a.BNumber, a.BOperId, a.Receiver, a.ReceiveTime, a.Total, b.MovNO1, b.MovNO2, b.MovNO3, b.MovNO4, b.Tel1, b.IDNumber, b.Tel2, b.Sex, c.DictonaryDesc AS sexName, TblManagement_2.SystemName AS BOperName, TblManagement_1.SystemName AS ReceiverName, ISNULL(a.CustomerName, '') + ISNULL(b.IDNumber, '') + ISNULL(b.MovNO1, '') + ISNULL(b.MovNO2, '') + ISNULL(b.MovNO3, '') + ISNULL(b.MovNO4, '') + ISNULL(b.Tel1, '') + ISNULL(b.PHCode, '') + ISNULL(b.Tel2, '') + ISNULL(b.Address, '') + ISNULL(a.BNumber, '') AS keyWords, b.Address, b.PHCode FROM dbo.TblManagement AS TblManagement_1 RIGHT OUTER JOIN dbo.TblBill AS a ON TblManagement_1.Mid = a.Receiver LEFT OUTER JOIN dbo.TblManagement AS TblManagement_2 ON a.BOperId = TblManagement_2.Mid LEFT OUTER JOIN dbo.TblCommonDictionary AS c RIGHT OUTER JOIN dbo.TblCustomers AS b ON c.Id = b.Sex ON a.ClientId = b.ClientId ORDER BY a.BId DESC GO
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[ViewBill]
AS
SELECT TOP (100) PERCENT a.CustomerName, a.BId, a.ClientId, a.BNumber, a.BOperId, a.Receiver, a.ReceiveTime, a.Total, b.MovNO1, b.MovNO2, b.MovNO3,
b.MovNO4, b.Tel1, b.IDNumber, b.Tel2, b.Sex, c.DictonaryDesc AS sexName, TblManagement_2.SystemName AS BOperName,
TblManagement_1.SystemName AS ReceiverName, ISNULL(a.CustomerName, '') + ISNULL(b.IDNumber, '') + ISNULL(b.MovNO1, '')
+ ISNULL(b.MovNO2, '') + ISNULL(b.MovNO3, '') + ISNULL(b.MovNO4, '') + ISNULL(b.Tel1, '') + ISNULL(b.PHCode, '') + ISNULL(b.Tel2, '')
+ ISNULL(b.Address, '') + ISNULL(a.BNumber, '') AS keyWords, b.Address, b.PHCode
FROM dbo.TblManagement AS TblManagement_1 RIGHT OUTER JOIN
dbo.TblBill AS a ON TblManagement_1.Mid = a.Receiver LEFT OUTER JOIN
dbo.TblManagement AS TblManagement_2 ON a.BOperId = TblManagement_2.Mid LEFT OUTER JOIN
dbo.TblCommonDictionary AS c RIGHT OUTER JOIN
dbo.TblCustomers AS b ON c.Id = b.Sex ON a.ClientId = b.ClientId
ORDER BY a.BId DESC
GO
我试了一下,问题在top (100) ,2008是没问题的,2000中这个括号是多余的,要去掉,否则报错