22,206
社区成员
发帖
与我相关
我的任务
分享
drop view if exists dbo.jcckd;
GO
CREATE VIEW [dbo].[JCCKD] with SCHEMABINDING
AS
SELECT
--A.ID,
A.xn,
A.xq ,
D.xy ,
A.lsrdw,
C.isbn ,
C.jcmc ,
C.cbs ,
C.bb ,
C.jczz,
C.price,
C.gys,
C.zk,
SUM ( B.qty ) AS cs,
'116#' sjh,
count_big(*) rn
FROM
dbo.OrderHeader A
INNER JOIN dbo.OrderDetail B ON A.ID = B.orderid
INNER JOIN dbo.abc D ON D.id = a.custid
INNER JOIN dbo.jcjbxxb C ON B.bookid = C.id
WHERE
a.qty > 0
AND a.type = 1
GROUP BY
--A.id,
A.xn,
A.xq,
D.xy,
A.lsrdw,C.isbn ,
C.jcmc ,
C.cbs ,
A.lsrdw ,
C.bb ,
C.jczz,
C.price,
c.gys,
C.zk
;
go
create unique clustered index IX_lsrdw_isbn_gys on jcckd(xn,xq,lsrdw,isbn,gys) --就这句话报错了。
CREATE NONCLUSTERED INDEX IX_xn_xq_XY_LSRDW
ON jcckd (xn,xq,xy,lsrdw);
create unique clustered index IX_lsrdw_isbn_gys on jcckd(xn,xq,lsrdw,isbn,gys)
> Msg 8668, Level 16, State 1, Server WIN-N6MMO17K755, Procedure , Line 0
无法对视图 'JCBNEW.dbo.JCCKD' 创建聚集索引 'IX_lsrdw_isbn_gys',因为该视图的选择列表包含聚合函数或组合列的结果表达式。请考虑从选择列表中删除聚合函数或组合列的结果表达式。
> [42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]无法对视图 'JCBNEW.dbo.JCCKD' 创建聚集索引 'IX_lsrdw_isbn_gys',因为该视图的选择列表包含聚合函数或组合列的结果表达式。请考虑从选择列表中删除聚合函数或组合列的结果表达式。 (8668)