当我在表中添加新列时，它会说INVALID COLUMN [英] When i am adding new column in the table it say INVALID COLUMN

问题描述

当我在SP中进行更改时，对已添加新列的表进行插入查询，在storedprocedure中也显示相同的错误，如INAVLID COLUMN

When i make changes in SP which has insert query for the table which i have added a new column , in storedprocedure also it show same error like INAVLID COLUMN

推荐答案

输入错误或不存在的列名时会出现无效列错误。请在插入语句中检查新添加的列名。

或

有时新添加的列不会刷新在SQL编辑器元数据中，因此它可能会在列名称下面显示红色下划线错误。如果是这样的话，您可以忽略它

Invalid Column Error occurs when you enter wrong or non existent column name.Please check Newly added column name in your insert statement.
OR
Sometime newly added columns is not refreshed in SQL editor metadata, hence it might show red underline error below column name.if it is the case you can ignore it

由于METADATA缓存未刷新而导致的intellisense错误消息!! < br $>




我们需要在更新/更改查询之前刷新sqlserver的元数据

按ctrl + shift + R

its an intellisense error message due to METADATA cache not refreshed!!


We need to refresh metadata of sqlserver before we update / alter the query by
pressing ctrl + shift + R

这篇关于当我在表中添加新列时，它会说INVALID COLUMN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！