問題描述

我們在項目中使用了兩個模式 (dbo + kal).

We're using two schemas in our project (dbo + kal).

當(dāng)我們嘗試使用以下 SQL 語句創(chuàng)建視圖時，Visual Studio 在錯誤列表中顯示為錯誤.

When we are trying to create a view with the following SQL statement, Visual Studio shows as an error in the error list.

CREATE VIEW [dbo].[RechenketteFuerAbkommenOderLieferantenView]
AS
    SELECT
        r.Id as RechenkettenId,
        r.AbkommenId,
        r.LieferantId,
        rTerm.GueltigVon,
        rTerm.GueltigBis,
        rs.Bezeichnung,
        rs.As400Name
    FROM
        [kal].[Rechenkette] r
    JOIN
        [kal].[RechenketteTerm] rTerm ON rTerm.RechenketteId = r.Id
    JOIN
        [kal].[Basisrechenkette] br ON rTerm.BasisrechenketteId = br.Id
    JOIN
        [kal].[Rechenkettenschema] rs ON rs.Id = br.Id
    WHERE 
        r.RechenkettenTyp = 0

錯誤信息如下所示:

SQL71501:計算列:[dbo].[RechenketteFuerAbkommenOderLieferantenView].[AbkommenId] 包含對對象的未解析引用.對象不存在或引用不明確，因為它可能引用以下任何對象:
[kal].[Basisrechenkette].[r]::[AbkommenId], [kal].[Rechenkette].[AbkommenId], [kal].[Rechenkette].[r]::[AbkommenId], [kal].[Rechenkettensschema].[r]::[AbkommenId] 或 [kal].[RechenketteTerm].[r]::[AbkommenId].

SQL71501: Computed Column: [dbo].[RechenketteFuerAbkommenOderLieferantenView].[AbkommenId] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects:
[kal].[Basisrechenkette].[r]::[AbkommenId], [kal].[Rechenkette].[AbkommenId], [kal].[Rechenkette].[r]::[AbkommenId], [kal].[Rechenkettenschema].[r]::[AbkommenId] or [kal].[RechenketteTerm].[r]::[AbkommenId].

發(fā)布視圖和工作就好了，但是在構(gòu)建我們的項目時一直看到錯誤消息很煩人，所有嚴(yán)重的錯誤都在那些 sql 錯誤的混亂中丟失了.

Publishing the view and working is just fine, but its quite annoying to see the error message all the time when building our project having all the serious errors get lost in the shuffle of those sql errors.

您知道可能是什么問題嗎?

Do you have any idea, what the problem might be?

推薦答案

我剛剛找到了解決方案.盡管我無法閱讀您的(似乎是德語)以了解您是否指的是系統(tǒng)視圖，但如果是，則必須提供對 master 的數(shù)據(jù)庫引用.否則，添加任何其他必需的數(shù)據(jù)庫引用應(yīng)該可以解決問題.

I just found the solution. Although I can't read your (what appears to be German) enough to know if you're referring to system views, if so, a database reference to master must be provided. Otherwise, adding any other required database references should solve the problem.

此處針對系統(tǒng)視圖進(jìn)行了描述:解析對對象信息架構(gòu)表的引用

This is described here for system views: Resolve reference to object information schema tables

和其他數(shù)據(jù)庫參考.

此處提供了其他信息:解決 SQL Server SSDT 項目中的歧義引用

這篇關(guān)于SQL71501 - 如何擺脫這個錯誤?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！