SQL Server: 无效的列名 [英] SQL Server: Invalid Column Name

问题描述

我正在修改现有的 SQL Server 存储过程.我向表中添加了两个新列，并修改了存储过程以同时选择这两列.尽管表中的列可用，但我不断收到此错误:

I am working on modifying the existing SQL Server stored procedure. I added two new columns to the table and modified the stored procedure as well to select these two columns as well. Although the columns are available in the table, I keep getting this error:

无效的列名INCL_GSTAMOUNT"

Invalid column name 'INCL_GSTAMOUNT'

谁能告诉我这里出了什么问题?

Can anyone please tell me what's wrong here?

推荐答案

每当我遇到这种情况时，我都会按 Ctrl+Shift+R 刷新intellisense，关闭查询窗口(必要时保存)，然后开始一个通常效果很好的新会话.

Whenever this happens to me, I press Ctrl+Shift+R which refreshes intellisense, close the query window (save if necessary), then start a new session which usually works quite well.

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