我在SQLServer上创建视图时加了个排序,执行后系统报如下错误,这是啥意思?不能用排序吗:
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
我创建视图的代码如下:
ALTER VIEW [dbo].[WF00048_ApprovalRecord] AS SELECT A.ID, A.RefNO, A.ProcInstID, A.EmployeeID, A.EmployeeName, A.Dept, A.Deadline, A.TruckSeries, A.PartNo, A.PartName, A.DrawingVersion, A.IsInvestment, A.InvestmentAmount, A.QTY, A.QualifiedSupplier, A.SupplierType, A.SupplierID, A.SupplierName, A.ExpectedArrivalDate, A.IsKeyPart, A.IsNeedET3, A.Remarks, A.FormStatus, A.CreateAt, A.Flag, A.OrderNo, A.PData, A.NData, A.CostCenter, A.RFQRequestID, A.CurrentActive, A.NoticeTrialAssemblyTime, A.NoticeTrialWeldingTime, A.SN, A.IsBackToSCP1, A.ApproveEndTime, A.DevelopTypeCode, A.DevelopTypeDesc, A.IsInterToDomestic, A.OrderArrivalDate, A.OldProjectType, A.NewProjectType, A.IsMadeToBuy, A.ProductionTime, A.DrawingNo, A.BuyerCode, A.InnerOrderNo, A.ChangeItemLevel1, A.ChangeItemLevel2, A.BackToApplicantNode, A.HasCheckOrder, A.UrgencyDegree, A.IsNewProject, A.SameTimeMaterial, A.PreviousActive, A.IsNeedSmallBatch, A.SmallBatchQty, A.IsOutsourcedPart, A.WriteSAPResult, A.Region, A.Factory, A.AccountSubject, A.IsWeldingPart, A.FixedSource, A.HasQA, A.PlannerEmail, A.QtyPerTruck, A.HadCheckTruck, A.CheckTruckRemark1, A.CheckTruckRemark2, A.HasMatingParts, A.MatingPartsRemark1, A.MatingPartsRemark2, A.PartBackground, A.PartBackgroundRemark, A.AssemblyDrawingRemark, A.RFQDataID, A.RFQAttachmentType, B.ID AS ApprovalID, B.EmployeeID AS ApproverEmployeeID, B.EmployeeName AS ApproverName, B.ApproveResult, B.NodeName, B.Comment, B.ApproveTime, B.ApproveResultCode FROM dbo.WF00048_ApplyForm AS A LEFT join dbo.Global_ApproveRecord AS B ON A.ID = B.FormID AND B.ApplicationNo = 'WF00048' ORDER BY A.ID ASC,B.ID ASC GO