Microsoft SQL Server Native Client 11.0错误＃4104 [英] Microsoft SQL Server Native Client 11.0 Error #4104

问题描述

我不知道我错过了什么。我试图从Access（2003）中的QueryDef内部运行以下SQL，但它不断返回错误：
[Microsoft] [SQL Server Native Client 11.0] [SQL Server]部件标识符tW.WE无法绑定（＃4104）

错误文本实际上在消息中实际发生了四次。

展开 | 选择 | Wrap | 行号

解决方案

我没有看到SQL的任何明显错误。


如果你不这样做，你会得到错误不是WE列的别名吗？


Employee表的DDL是什么？

我也看不到任何东西。你可以自己运行子查询，它会给你同样的错误吗？如果您可以给我们两个表的DDL，我们可能能够重新创建问题并且可能能够提供更多帮助。


您可能能够避免子查询加速你的过程。它看起来像INNER连接和NOT EXISTS where子句。如果没有额外的细节，将无法完全确认。


~~ CK

首先，我可以确认我在所有错误中都得到了同样的错误我检查过的情况。这显然包括取出各种ALIASES，以及重命名[tblWE]和其中的[WE]字段。


对于DDL，我假设你的意思是指定的布局当我将脚本创建到窗口时，我得到了。让我警告说，[员工]的大部分内容都与此无关（在我的估计中），但为了完整性，我会将其全部包括在内。我知道结构有很多不足之处，但在现场系统中，很难做出根本性的改变而不会造成我们目前无法负担的悲伤。

展开 | 选择 | Wrap | 行号< /跨度>

I don''t know what I''m missing. I have tried to run the following SQL from inside a QueryDef in Access (2003) but it keeps coming back with the error :
[Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier "tW.WE" could not be bound (#4104)
That error text actually occurs four times in total in the message.

Expand|Select|Wrap|Line Numbers

解决方案

I don''t see anything explicitly wrong with the SQL.

Do you get the error if you don''t alias the WE column?

What is the DDL of the Employee table?

I don''t see anything either. Can you run the subquery on its own and will it give you the same error? If you can give us the DDL of both tables, we might be able to recreate the issue and might be able to assist more.

You might be able to avoid subquery either to speed up your process. It looks like INNER joins and a NOT EXISTS where clause will do. Will not be able to completely confirm without additional details.

~~ CK

Firstly, I can confirm that I get the same error in all situations I checked. That explicitly does include taking out the various ALIASES, as well as renaming [tblWE] and the [WE] field within it.

For DDL I assume you mean the layout as specified by what I get when I Script CREATE to a window. Let me warn that much of the table [Employees] is irrelevant to this (in my estimation), but I''ll include it all anyway for completeness. I know the structure leaves a lot to be desired but in a live system it''s hard to make fundamental changes without causing grief we can ill afford currently.

Expand|Select|Wrap|Line Numbers

这篇关于Microsoft SQL Server Native Client 11.0错误＃4104的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！