sql-server – 使用主键创建视图？

发布时间：2020-12-12 16:09:01 所属栏目：MsSql教程来源：网络整理

导读：我创建一个包含以下代码的视图 SELECT CONVERT(NVARCHAR,YEAR(okuma_tarihi)) + 'T1' AS sno,YEAR(okuma_tarihi) AS Yillar,SUM(toplam_kullanim_T1) AS TotalUsageValue,'T1' AS UsageTypeFROM TblSayacOkumalariGROUP BY CONVERT(NVARCHAR,YEAR(okuma_tarih

我创建一个包含以下代码的视图

SELECT
    CONVERT(NVARCHAR,YEAR(okuma_tarihi)) + 'T1' AS sno,YEAR(okuma_tarihi) AS Yillar,SUM(toplam_kullanim_T1) AS TotalUsageValue,'T1' AS UsageType
FROM
    TblSayacOkumalari
GROUP BY
    CONVERT(NVARCHAR,YEAR(okuma_tarihi)) + 'T1',YEAR(okuma_tarihi)

UNION ALL

SELECT
    CONVERT(NVARCHAR,YEAR(okuma_tarihi)) + 'T2' AS sno,SUM(toplam_kullanim_T2) AS TotalUsageValue,'T2' AS UsageType
FROM
    TblSayacOkumalari
GROUP BY
    CONVERT(NVARCHAR,YEAR(okuma_tarihi)) + 'T3' AS sno,SUM(toplam_kullanim_T3) AS TotalUsageValue,'T3' AS UsageType
FROM
    TblSayacOkumalari
GROUP BY
    CONVERT(NVARCHAR,YEAR(okuma_tarihi)

我想定义CONVERT(nvarchar,YEAR(okuma_tarihi))’T1’作为sno作为主键是可能的？如果可能,我该怎么办？

解决方法

您无法在视图上创建主键.在SQL Server中,您可以使用 create an index on a view,但这与创建主键不同.

如果你给我们更多的信息,为什么你想要一个关键在你的看法,也许我们可以帮助.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!