SQL Server Data Tools (SSDT) 警告未解析的表引用，但该表存在 [英] SQL Server Data Tools (SSDT) warns of an unresolved table reference, but the table exists

问题描述

SSDT 抱怨在存储过程的代码中，引用的表不存在.警告 SQL71502.

SSDT complains that within the code of a stored procedure, a referenced table does not exist. Warning SQL71502.

但是表确实存在，并且它的定义是有效的.该表不在在另一个数据库中，它甚至可以在智能感知菜单中正确显示.这是一个非常简单的小型数据库，问题仅在本地存储过程和本地表之间.两个脚本都设置为 Build.

But the table does exist, and its definition is valid. The table is not in another database, and it even appears correctly in intellisense menus. This is a very straightforward, small database and the problem is just between a local stored procedure and a local table. Both scripts are set to Build.

如何删除这个无效警告?

How can I remove this invalid warning?

推荐答案

已解决 - 有时您只需要离开一会儿.存储过程中的一对括号会触发 SSDT.它没有导致构建错误或语法错误，但以某种方式混淆了解析器，以至于表名无法正确链接到表的定义.

Solved - sometimes you just have to step away for a bit. A pair of parentheses in the stored procedure was tripping up SSDT. It did not cause a build error or syntax error, but was confusing the parser somehow such that the name of the table could not be correctly linked to the definition of the table.

这篇关于SQL Server Data Tools (SSDT) 警告未解析的表引用，但该表存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！