无效的对象名称 sql [英] Invalid Object Name sql

问题描述

我的 sql 代码不断收到无效的对象名称错误.(member_number,subscriber_policy_number) 带有错误消息下划线.

I keep getting an invalid object name error on my sql code. (member_number, subscriber_policy_number) is underlined with the error message.

代码本身运行良好，没有错误，为什么会发生这种情况?上面的代码都没有突出显示

The code itself runs fine with no errors, why does this happen? None of the code above this is highlighted

update smmdmm.aid_data
set Member_Number = Subscriber_Policy_Number
where Member_Number in ('000000000','000000001')

推荐答案

确保您使用的是正确的数据库.它可能默认为主"数据库，并且看起来您没有引用表的完整架构.

Make sure you're using the correct database. It may be defaulting to the "Master" database, and it doesn't look like you have the full schema for the referenced table.

例如:[DatabaseName].[Schema].[TableName] 或 [Database1].[smmdmm].[aid_data]

希望这会有所帮助.

这篇关于无效的对象名称 sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！