如何解决 SQL Server 中的“无效对象名称"? [英] How to solve 'invalid object name' in SQL Server?

问题描述

这是返回的错误信息:

消息 208，级别 16，状态 1，第 1 行无效的对象名称ENG_PREP".

Msg 208, Level 16, State 1, Line 1 Invalid object name 'ENG_PREP'.

它发生在我尝试以下查询之后:

It happens after I try the following query:

insert into ENG_PREP VALUES('572012-01-1,572012-01-2,572012-01-3,572013-01-1,572013-01-2',
'',
'500',
'',
'A320 P.001-A',
'Removal of the LH Wing Safety Rope',
'',
'',
'',
'0',
'',
'AF',
'12-00-00-081-001',
'',
'',
'',
'',
'',
'',
'' )

推荐答案

这并不一定意味着它在您的 SQL 插入查询本身中找不到ENG_PREP".检查在该表上运行的所有触发器，并确保所有触发器的表名拼写正确.

It doesn't necessarily mean that it can't find "ENG_PREP" in your SQL insert query itself. Check any triggers that run on that table as well and make sure all of them have the exact table name spelled correctly.

这只是在调试存储过程时发生在我身上，我花了半个小时才找到它.

This JUST happened to me when debugging a stored procedure and it took me half an hour to find it.

这篇关于如何解决 SQL Server 中的“无效对象名称"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！