SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL,ARITHABORT,QUOTED_IDENTIFIER,ANSI_NULLS ON
GO
Create view vw_imps_PcClient_DownloadLog
with SCHEMABINDING
as
select CONVERT(DATETIME,CONVERT(VARCHAR(10),LogDateTime,120)) as LogTime,Version ,min(LogId) as logId,count(1) as [Count]
from dbo.imps_PcClient_DownloadLog l, dbo.imps_PcClient_Versions v where l.ClientVersionId = v.ClientVersionId
group by CONVERT(DATETIME,CONVERT(VARCHAR(10),LogDateTime,120)),Version
CREATE UNIQUE CLUSTERED INDEX vw_imps_PcClient_DownloadLog ON vw_imps_PcClient_DownloadLog (LogTime,Version)
视图创建成功
创建索引时提示 : 无法创建索引,因为键列 'LogTime' 不具有确定性或不精确。
这该如何改呢
请各位老大指点一下
select CONVERT(DATETIME,CONVERT(VARCHAR(10),LogDateTime,120)) as LogTime
改为:
select LogDateTime as LogTime
改为:
select LogDateTime as LogTime
另外,检查一下你的数据,聚集索引不允许有重复值,视图必须建立聚集索引才能建立其他索引,