SSDT不喜欢我的计算列 [英] SSDT doesn;'t like my computed column

问题描述

我有一个有计算字段的表。

I have a table that has a computed field.

以前，这是一个简单的公式并且工作正常。

Previously, it was a simple formula and worked fine.

I已将其更改为使用用户编写的函数，如果我直接在SSMS中输入字段定义，则可以正常工作。 没问题。

I have changed it to use a user written function, which if I put into the field definition directly in SSMS, it works fine.  No problem.

尝试在Visual Studio中更新我的项目时，看起来它在构建试图运行时不喜欢它，SSDT似乎讨厌它。

Trying to update my project in Visual Studio, it appears that it doesn't like it when the build tries to run, SSDT seems to hate it.

    [RfiNumber8RightMost]鸟            AS                  Rfi.RfiNumberRightmost（RfiNumber），

    [RfiNumber8RightMost]             AS                  Rfi.RfiNumberRightmost(RfiNumber),

它告诉我"字段"包含对象的未解析引用。  EIther对象不存在或引用不明确，因为它可以引用以下任何对象 

It tells me that the field "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 

Stockton

推荐答案

您的表格是否与您的函数具有相同的架构Rfi？

Is your table has the same schema Rfi as your function?

这篇关于SSDT不喜欢我的计算列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！